Group: microsoft.public.access.reports
From: =?Utf-8?B?aGRmaXhpdHVw?=
Date: Tuesday, October 23, 2007 7:59 AM
Subject: Sort Order

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.