Data order in reports

[Guest]

I have a report based on a table. The field that I want to sort is a name
field based on a lookup list. the lookup field is two columns, NameID and
Name. My report prints out the name (not the NameID number) but it sorts the
names by the NameID number and not alphabetically by name. In the row source
query it queries NameID and Name from the name table and it says to sort by
name, yet is still sorts by NameID? Is my question clear and can you help me?

 

[Duane Hookom]

Add the lookup table to your other table in the report's record source to
create a query joined on the appropriate fields. You can then add the [Name]
field to the report and sort by it.

BTW: most of us recommend that you never use lookup fields in table designs.
Also, Name is a poor name for a field since every object has a name
property.