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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel does not accept text format! 0
Embed the same Excel multiple times 0
Insert Index into a Table 1
Alphabetization crazies. 6
Finding the right style field in VBA 0
Using Styles In An Outline 0
Synchronization problems while moving folders to new email 1

Top