Multiple record report (1 Viewer)

Hi All,

I have a form with a sub form, the main form may have 1 record where the sub form may have anything from 1 to 6 record or upwards.
I need to create a report to display only the amount of records that was entered in the form, which the number of records vary for each record in the main form. my question is, can a report be created to automatically adjust according to the amount of records in the sub form. I have 2 tables which the data is entered into.

you will have to make a query to pull those exact records from both tables....
select * from table1, table2 where table1.ID = table2.ID and
table1.id = forms!myForm!txtID

then you can make the autoreport, that will build it somewhat correctly.
youll most likely have to adjust the report.
But its still pretty easy.

Yes. You can either make a report/sub-report (one based on each table). Or you can create a query and then use 1 report and Grouping Levels in the report to make it display correctly.