requery?

  • Thread starter Thread starter Joetta
  • Start date Start date
J

Joetta

How can I use a requery event to sort a report as needed.
For example, I need a button to run a report grouped by
[City] then sorted by by [LastName]. A second option
button will sort by [LastName] only. A third will sort by
[SeniorityDate].

Maybe requery is not the right way to do this? Would a
requesry macro do this? Any help is appreciated!!

Thank you - Joetta
 
If you have nothing in the report's Sorting And Grouping dialog, you can set
the OrderBy property of the report, e.g.:
Reports![MyReport].OrderBy = "City; LastName"
Reports![MyReport].OrderByOn = True
In a macro, that would be the SetValue action.

If you are using the Sorting and Grouping, you can reassign the
ControlSource of the GroupLevel in the Open event of the report. Details:
http://allenbrowne.com/ser-33.html
 
Back
Top