How do I pass variables for 'Sorting and Grouping' in a report?

[Guest]

We can have data source an sql query, a query name or a table name by sorted.
But in case I want grouping, without using 'sorting and Grouping' provided in
the report. Need to pass grouping variable thru code?

 

[Allen Browne]

For an example, see:
Sorting Records in a Report at run-time
at:
http://allenbrowne.com/ser-33.html

In Access 2002 or 2003, you can pass the value(s) in the OpenArgs of the
report. In earlier versions, use a public string variable.