report

[tiago]

i want to do a report in access, where i nedd information from 2 forms, for example:

I have a form called Invoices and another called receive.

and i want the report to show this, from one single client:



Invoice nº1 $1000
Invoice nº2 $500
Invoice nº3 $1200
Receive nº1 $-1000

Total $1700

 

[tlbroadbent]

Here are my assumptions.
[ol][li]When you say you need information from two forms, you mean you have information stored in two tables of the database.
[li]One table contains Invoices. The other table contains Receivals.
[li]You want to report this information like your example.[/ol]This then is my suggestion.
[ol][li]Create a query that looks like this...
Select Client, Invoice, Amt
From Invoices
Union
Select Client, Invoice, Amt
From Receivals
[li]Save the query
[li]Use the Report Wizard to create a report based on the saved query. Select summary options to summarize Amt.
[li]Save the report.[/ol]This is very simplified but you should be able to fill in the gaps. Of course, if my assumptions are wrong, I'll need clarification. Terry

;-) I never worry about the future. It comes soon enough. -Albert Einstein

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm