report from 2 forms

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

stephendeloach via AccessMonster.com

I have created 2 forms, 3rd Party and Drilling Invoice. How can I make a
report that summarizes both of these forms? In the report needs to be each
invoice from both forms. Including the line items from each invoice number...
Thanks
 
stephendeloach via AccessMonster.com said:
I have created 2 forms, 3rd Party and Drilling Invoice. How can I make a
report that summarizes both of these forms? In the report needs to be each
invoice from both forms. Including the line items from each invoice
number...
Thanks
Click to expand...

You don't report from forms, you report from either a table or a query. What
you need to do is build a query that joins the tables underlying the 2
forms, then base your report on that query.

Carl Rapson
 
Back
Top