Dear Richard, I made a query to select data presented in a report. I am working with Access 2000 or 2002; confusing thing, the info in Access itself says 2002, the database windows say 2000?!! In order to get the results I wanted I sorted the ID fields of several data-fields I want to have in my report. But sorting on the ID fields doesn't give the expected results. Reason for example; the Quality of wine in my database from low to high might be; QmP as lowest quality and Icewine as highest. In between are several others and picking the Quality from the Combobox (with NotOnList)I don't want to see them in Alphabethical order. Also other fields in order to present the report more detailed are sorted. The sorting order is the same in the query as I want them to show up in the report. What to do to overcome this problem?
Thankx
Reply from Richard Rost:
You might be using Access 2002, but your database might still be using the Access 2000 format. That's not a big deal. I wouldn't worry about it right now.
Any time you pull data into a REPORT, the REPORT is going to control the sorting - and will often ignore the sorting in a query. You need to set up a SORTING AND GROUPING LEVEL in your report to handle the sort there. This is covered in Access 104.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.