ID number vs Information

[VTXscooter]

On one of my reports I have a site location that comes up as a ID number instead of the info in SITE_LOCATION.

Is there a filter to change the ID number to the Wording?

Thanks, Joe

 

[ColinEssex]

If your site names are in a seperate lookup table, put that in the query behind the report and select the site name instead of the siteID.

Or, you could check out the IIF() function in Access help.

Col

 

[VTXscooter]

I have started over and am still having trouble. The report references a mastery inventory table that has a lookup field that referencers several locations. When I run the report I get the ID number of the location as oppossed to the Name of the location.

Is there some sort of filter in the lookup table that allows me to toggle from the ID to the name of the site?
Thanks, Joe