Combining records from multiple tables into one query

[sgp667]

Hi guys how can I combine records from different tables into one query?

For example I need a query for a form that shows client's balance history, where Invoices/Bills and Payments are coming from two different tables.
Here is an example how this might look on the report:

1/1/2012 Invoice $500
1/8/2012 Payment $250
2/1/2012 Invoice $500
2/8/2012 Payment $750

Like I say Invoices would come from one table and Payments from another, and because it is relevant to another project of my lets assume that I cannot combine the two tables into one.

Thanks

[June7]

A UNION query could probably get that output, something like:

SELECT DateField, "Invoice" AS Type, Amount FROM Invoices
UNON SELECT DateField, "Payment", Amount FROM Payments;

There is no designer for UNION, must type into the SQL view window.