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

How to keep new group footer at the bottom of other group footers

P: 23
Hi,

I am trying a report which needs to be grouped by invoice number, transdate.
The existing report already grouped by invoice number.Now I am trying to include transdate in the list. But the transdate footer is including at the top side of invc num, but I need at the bottom. I need like the following.

invocenumber header

invoicenum footer
transdate footer

Can anyone help......please
I am using access 2000
May 21 '07 #1
Share this Question
Share on Google+
1 Reply

Rabbit
Expert Mod 10K+
P: 12,441
Hi,

I am trying a report which needs to be grouped by invoice number, transdate.
The existing report already grouped by invoice number.Now I am trying to include transdate in the list. But the transdate footer is including at the top side of invc num, but I need at the bottom. I need like the following.

invocenumber header

invoicenum footer
transdate footer

Can anyone help......please
I am using access 2000
This is because it is grouped by invoice number first. To get it to be the outer group, you'll need to group by transdate first and invoice number second.
May 21 '07 #2

Post your reply

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