Report changed sort field

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,
On my Access 2000 application, I have an query result
screen, on the screen there is a "Print" button to print
report. Both screen & report are based on same query.
Now on the query result screen, it dispaly different
fields, e.g. Class No, Attend Date,Unit... If the user
click on Class No, the query result will order by Class
No, if the user click the Attend Date , the result will
order by Attend Date.
The report is now sort by Class No. How can I print the
report based on users sorting order?
Thanks for your kindly advise.
 
Paul

The sort order and grouping of Reports are independent of what you may have
set in your Queries.

You'll need to specifically set the sort order in your report as well.
 
Back
Top