Lookup Value Sorting in Reports

[Robert D. Vanderslice II]

I hope that someone can lead me in the right direction with an issue that
I've encountered in an Access 2003 database.

I have two tables that have a relationship between them. When I print a
report based on table 1, the value that is returned from table 2 prints;
which is what I wish. What doesn't seem to happen, is proper sorting. The
report is sorted by the lookup key information, not the value that it
returns.

How do I get the report to sort in the lookup value order, not the lookup
key order?

Thank you for your time.

Robert

 

[gz]

As a work around, I guess you can create a query, sort in the query and
lookup the query.

 

[Duane Hookom]

Add table 2 to your report's record source.
If you are using lookup fields, consider reading
http://www.mvps.org/access/lookupfields.htm about the "evils" of lookup
fields.