Reply : Allen Browne

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
 
A

Allen Browne

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.
 

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

Need to sort a report assending but it won't do it. 2
sorting numerical values 2
Trying to get my report to sort correctly 3
Sorting and Grouping Option 1
text box datasource refer to a field in a table 2
Access 2007 Report shows multiple rows, query shows single row 0
Stored Company Logo 7
For Duane Hookom 1

Top