Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

new page

Status
Not open for further replies.

abdhab

MIS
Dec 10, 2006
51
CA
hi
i have this simple report that show the summary and the details from 2 tables with 1 to many relations
i just need the report to show each unique summary (with its details for sure) on a single page

example:
summary1 summarydescription1
detail1 detaildesc1
<new page>
summary2 summarydescription2
detail1 detaildesc1
detail2 detaildesc2
<new page>
summary3 summarydescription3
detail1 detaildesc1
...

thanks
 
Use a query as recordsource for your report.
Use the "Totals"-button in your toolbar to create groups, counts and sums.
Save the query and create the report with this query as record source.

Herman
Say no to macros
 
i reposted the question in the reports forum
please remove it from here
 
please remove it from here
Did you click the Red Flag link ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top