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

Summary Report

P: n/a
Hello,

I need to create a report summary that displays data from 8 individual
reports. The control source for each individual report is a distinct
query. I am currently using an unbound report with
selected fields from each individual report to compose the summary
report.
Client totals, such as =sum([client]) are accurate for each individual
section. The problem is with displaying the actual clients on the
summary report. =[client]. On the individual report for instance, 20
client names display but on the report summary, only the first name
shows. I am stumped. How can I get this to work?

Thank you
Jan 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
cgiscri wrote:
Hello,

I need to create a report summary that displays data from 8 individual
reports. The control source for each individual report is a distinct
query. I am currently using an unbound report with
selected fields from each individual report to compose the summary
report.
Client totals, such as =sum([client]) are accurate for each individual
section. The problem is with displaying the actual clients on the
summary report. =[client]. On the individual report for instance, 20
client names display but on the report summary, only the first name
shows. I am stumped. How can I get this to work?

Thank you
Maybe make the report bound.
Or maybe make a subreport
Or futz around with MoveLayout, NextRecord, PrintSection Properties

Space
http://www.youtube.com/watch?v=N1Hs2AQwDgA
Jan 29 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.