Using Sub-report to get desired results

M

Melinda

Hello,
I had a similar problem with invoices and found that a
Union Query worked quite well. You have to use a little
SQL, but the Access help has good guidance. You can get
to an SQL window by creating a new query in the design
view and then selecting SQL from the View menu.
 
Top