Using a Query for 2 tables

[lizray]

I have 2 tables containing fields for Date and Amount, each relates to a different source and must be kept separate. Sometimes I want a combined result sorted by date. I would rather not use a third table for the combnination.How do I set up the query to combine the tables?

 

[PHV]

An UNION query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Dontremb]

Union query seems the way to go, from what I understand. It puts all the data from one table first, then the second table AFTER the fields from the first.

I have no idea how to actually DO one of these, but I'm sure it's easy to find.

 

[lizray]

I am not very familiar with SQL, but problem is now solved,Many thanks PHV.