alphabetically or numerically

  • Thread starter Thread starter Pishoy
  • Start date Start date
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
 
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.
 
Back
Top