Re: MS Access 2003 (how to put a item number in ascending order to my report)?

Question

guys heres my dilema... I have created a report (delivery report) were each client i encoded shall be sorted by group, does when i encode the datas from the form it will be sorted according to client. eg. No. Cient Orders Date Delivered
1 A 4,500pcs 10-12-06
2 B 3,000pcs 11-25-06
3 A 1,000pcs 12-01-06
From above example the comp will sort it according to client group so when i print its report its sorted already however my problem is the number is not in ascending order because it will be sorting the group which was the first data data was encoded. So from above the order will be ( 1 A 4,500 10-12-06)
3 A 1,000 12-01-06
guys how can i number it automatically in ascending order???

Answer 1

It's difficult to answer such a specific question here on Yahoo answers because we really don't have a back-and-forth dialog here. You might want to try something like this forum:
http://www.utteraccess.com/forums

However, if your "No." is a field in your database (and not just a line number in your report), then you can create a query on your table that first sorts the information, then use THAT as the source for your table.

Good luck!