2 tables in one column? (1 Viewer)

[Mario]

Hello,

This might be easy but I can't find how to do it. Here is the problem:

I have 2 tables: tblCommissions and tblExpenses
Both tables have a field named "Payment Date To Be submitted" and both table have to be separated (don't tell me to make only one table).

Now I want to take both of those 2 fields and create a query that will list in ONE column all unique value.

Example:
tblCommissions tblExpenses
15-mar-03 15-mar-03
16-mar-03 17-mar-03
18-mar-03

so the query should return:
15-mar-03
16-mar-03
17-mar-03
18-mar-03

Thanks

 

[KevinM]

Look up UNION QUERY on the Help Files

 

[Mario]

Indeed. I knew it was easy. Thanks for your time.