Dynamically Sort Report That Already Has Group By (Access 2003)

[Maa421s]

I must use XP/Access 2003 to solve this problem for reasons I won't get into.

I have a report with a Group by on City.
The users need to be able to sort by Coordinator within that OR by Client Name based on a selection they make on the form that opens the report.

-- I have tried to set .OrderBy
-- I have tried to set .RecordSource to different queries with order by hardcoded in them (I only have 2 sort options fortunately)

Is there a way to dynamically change the "Sorting and Grouping" defined in the report? This seems to be the only sorting that the report is responding to.

If this is totally obvious, forgive me as I have very little Access 2003 Reporting experience.

[June7]

Google: Access report dynamic sort

Here is one http://msgroups.net/microsoft.public...-sorting/93304

[Maa421s]

Great! Thank you June7! It worked flawlessly.

I don't know how to mark your reply as the answer...

[June7]

This forum doesn't have that feature. Can mark thread as solved, which I will do.