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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to print section with two records in report
- Thread starter mart991
- Start date
If I understand your question is similar to having an Invoice table and a InvoiceDetail table combined as the recordsource of a report. This is grouped by Invoice and I don't want to print any invoices that don't have 2 or more InvoiceDetail records.
Is this correct? If so, you may need to create a new query of the detail table that groups by InvoiceID and counts the number of InvoiceDetail records. Join this new query into your report's record source query so you can filter out those where the count is <2.
Duane
MS Access MVP
Is this correct? If so, you may need to create a new query of the detail table that groups by InvoiceID and counts the number of InvoiceDetail records. Join this new query into your report's record source query so you can filter out those where the count is <2.
Duane
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question