Open report with data sorted in ascending order
In my database as attached, I have a report
subrptqryQtyTypes based on qryQtyTypes
which I want to open with records in an ascending order of "VinTypeID" . I dont get it do open in ascending order.
Will you please have a look if you can fix it and/or tell me how.
ProblemReport.accdb
subrptqryQtyTypes based on qryQtyTypes
which I want to open with records in an ascending order of "VinTypeID" . I dont get it do open in ascending order.
Will you please have a look if you can fix it and/or tell me how.
ProblemReport.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's not obvious ... until you know about it ... and now you do :-)
Note that worse ... JET still does the sorting in the query - wasting time :-(
I notice you are Grouping by several fields in the query. You might want to rethink that also ... and do it in the report, which may likely be more efficient ....
mx
Note that worse ... JET still does the sorting in the query - wasting time :-(
I notice you are Grouping by several fields in the query. You might want to rethink that also ... and do it in the report, which may likely be more efficient ....
mx
ASKER
THANKS!
ASKER