Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Reports - how do you display the

Resolved · High Priority · Version 2003

Reply Tue 22 Jul 2008, 11:04Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Tue 22 Jul 2008, 12:11Delegate 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....

Access articles

· Three Myths About Microsoft Access
· Access 2007 Is All About Systems
· How Reorganising Your Data Can Take Your Business to the Next Level
· Discover How To Link An Excel Spreadsheet To An Access Database
· The Benefits of Certified Microsoft Training in Access

Please browse our web site to find out more about
ms access course and other Microsoft training courses.

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