Forum home » Delegate support and help forum » Microsoft Access Training and help » Reports - how do you display the

Reports - how do you display the

ResolvedVersion 2003

Tue 22 Jul 2008, 11:04 Delegate Chris said...

Chris has attended:
Access Advanced course

Reports - how do you display the

I have a list of values in a table that are from a lookup column so 1=Oxygen, 2=Sleep, 3= TB etc.
In my report I want it to display Oxygen, Sleep and TB and not 1, 2 and 3. The report is getting it's information from a query which when run on it's own displays Oxygen, Sleep and TB but when put into a report displays 1, 2 and 3. How do I make it so the report displays Oxygen, Sleep and TB?

Chris

Tue 22 Jul 2008, 12:11 Delegate Chris said...

RE: Reports - how do you display the

I've answered my own question. The solution is to include the table in the query from which the lookup column is getting it's data from! Simple when you know how....

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Reports - how do you display the

Reports - how do you display the

RE: Reports - how do you display the

Access articles

Access tip:

Hiding Multiple Table columns