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

DCount in Report or Creating Grouped Summary in Footer of Report

P: 5
Hi,
I am using Access 2003 and need a report to show details and then a summary at the bottom that separates by market. I see that I could group, then put a summary after each group but I need the details on the top and the summary at the bottom.

I have 2 queries- one for the details and one for the summary. If there was someway to link the Report to both queries?

Also I thought I could enter the markets in as Labels, then use DCOUNT to count only the data from a unique market. I would just need to count all market in the report that were in a certain state.

Better ideas or help with these?
May 30 '07 #1
Share this Question
Share on Google+
1 Reply

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,
I am using Access 2003 and need a report to show details and then a summary at the bottom that separates by market. I see that I could group, then put a summary after each group but I need the details on the top and the summary at the bottom.

I have 2 queries- one for the details and one for the summary. If there was someway to link the Report to both queries?

Also I thought I could enter the markets in as Labels, then use DCOUNT to count only the data from a unique market. I would just need to count all market in the report that were in a certain state.

Better ideas or help with these?
Have a look at using subreports for the details and summary
Jun 1 '07 #2

Post your reply

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