microsoft.public.access.reports

It's just a matter of assigning the ControlSource of the GroupLevel

Example here:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"hdfixitup" wrote in message
news:F31CC480-F6D3-4662-90BF-4926BCC09013@microsoft.com...
>I currently use two reports so I can sort on two different fields. I would
> like to have one report with two fields (Number1 and Number2). From a
> Option
> Group on a form, I would select Sort Order - either Number 1 or Number 2.
> When the report opens, it would sort based on my selection in ascending
> order. What do I need to place in the Sorting and Group Options on the
> report
> and what code needs to be added to the OnOpen event of the report? Can
> anyone help me? I have tried numerous possibilities with no such luck.