alphabetically or numerically

P

Pishoy

I have a report that should list the company's
alphabetically but it is not. it is listing them
numerically based on the number in the look up table so
it's (1, 10, 11. 19, 2, 20, 21...)
The table is linked to many things ...so ican't change any
thing in the table

Thanks for your help
Pishoy
 
A

Allen Browne

Open the report in Design View.
Open the Sorting And Grouping dialog (View menu).
Select the Company Name field.

The order of records in a report is defined by this dialog, not by the
source records in the query.
 
Top