report from 2 forms

  • Thread starter stephendeloach via AccessMonster.com
  • 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
 
C

Carl Rapson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Errors in Report total fields 19
=iif Calculated field in report? 3
create report based on data from other form? 7
Mail Merge with a many-to-one report/query 1
Limiting report data in the report and not in the query 4
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Report To Snapshot 4
page header on second page of invoice. 3

Top