how do I create this report

[sharonc]

I need to create a report that looks like the following:
It has a header section and then two identical forms follow it:

Header section
labid: AZ0515

Form1
storet: 00094
sampling date1 9-13-2003 results1
sampling date2 10-13-2003 results2
sampling date3 11-13-2003 results3

Form2
storet: 00400
sampling date1 9-13-2003 results1
sampling date2 10-13-2003 results2
sampling date3 11-13-2003 results3

Can someone tell me how I can create the header and the two forms on each page of the report?

 

[GingerR]

Hi. What have you tried so far?

First I'm wondering why you want to put forms onto a report?

Unless I'm missing something, this looks pretty straighforward to me. Have you consulted the Northwind database, a text book, or HELP?

Once you create your recordsource for the Report (table or query), it looks like you'd want to use the Sorting and Grouping feature to GROUP on both labid and storet, and make both of them GROUP HEADERs. Then just put the details in the DETAIL SECTION.

Hope this helps.

g