Reply : Allen Browne

  • Thread starter Thread starter Pishoy
  • Start date Start date
P

Pishoy

I already have that and the company name in sorting and
grouping is "Assending"...but the company name in the
query is a look up table linked to Company name table and
it's displaying it in the same order.
How can i make the report assending based on the company
name not the number ID

Thanks again
 
Change the query so it includes the Company name table as well.
Drag the company name into the query output grid.

Now the company name field is in the record source of the report, you can
specify that field in the Sorting'n'Grouping dialog.
 
Back
Top