By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

two options in the same report

P: 23
Hi

I have a form which has two options invoice number and transaction date .
When I select the first option to display from a table by sorting invoice number and transaction date, after that I need to display the totals for each invoice number as invoice footer.
When I select the second option to display from the same table by sorting transaction date and invoice number , after that I need to display the totals for each transaction date, as date footer.

Is it possible to display both the above options in same report. I am using access 2000.

can anybody help... Please
May 16 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
One way you can do it is by setting the grouping and/or sorting Levels in code in response to selection made in a combobox as shown in the following link:

http://www.fabalou.com/Access/Reports/sortorder.asp
May 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.