Problems printing a lookup field

[Mike Waters]

Hello,
I'm having an interesting problem that i can't seem to
solve. I have a table with a lookup field in it, and I've
entered data into the table. I then created a report to
view the information in the table. The report is supposed
to group the date by the lookup field, then by the next
field, and then sort by the last field. When I first
created the report, it worked fine, then I saved
everything and went to lunch. When I got back from lunch,
nad tried the report, it now gives me the integer values
of the locations of the items in the lookup field. I
can't get the reorpt to go back to showing the actual item
names. If anyone has any suggestions, please E-mail me at
(e-mail address removed)

Thank You
Mike

 

[Duane Hookom]

Assuming your lookup is based on a table or query, include this table in
your report's recordsource. This is another good reason to read and follow
http://www.mvps.org/access/lookupfields.htm