Creating multiple reports

[Geoffrey]

I know this should be easy. The end result I'm looking for is to have a rep
group and a date range selected in a form, and from that all of the rep
group's invoices for that period would be generated. I've used two queries
that hit our SQL ERP backend to create a report and sub-report producing a
nice looking invoice (report). A third query pulls SQL data from the rep
group/date range form I made, and correctly finds all the correct invoice
numbers for the selected period. If I put an invoice number manually into
the Invoice number criteria field for the two Invoice Report querys, I
generate an accurate and nice looking invoice. But I'm still rather new to
this stuff, and I can't figure out how to pull the invoice numbers from the
third query one at a time to create one invoice report for each invoice
number. I suspect that I should be using grouping in the report, but I've
failed to make that work correctly. Thank you for any thoughts on this
matter.

 

[Bob]

You need to create a query that pulls the criteria from
your form and use that as your record source for the
report (invoice). When designing the query use criteria
similar to the following:

=Forms![MyForm]![RepGroup] for your Rep Group criteria

Between [Enter start date] And [Enter end date] for your
invoice date field criteria.

When the query runs Access will prompt the user for the
beginning and ending dates for the report (The prompt will
be whatever you type in the brackets).

Sort the query by InvoiceNumber and group your invoice
report on InvoiceNumber as well.