Need help...

[Guest]

In my DB I have 2 tables.

Table1 has two columns: Date, Amount
Table2 has two columns: Date, Amount

I need a query which can put all the values from Date fields of both tables
into one column (to get the list of available Date values).

Is it possible?

Thank you for any tips!

 

[RoyVidar]

Mike wrote in message

In my DB I have 2 tables.

Table1 has two columns: Date, Amount
Table2 has two columns: Date, Amount

I need a query which can put all the values from Date fields of both
tables into one column (to get the list of available Date values).

Is it possible?

Thank you for any tips!

You should be carefull with the naming, and not use Date as the name
of a field, cause it is also a function ... If I've undestood correct,
in the SQL view of the query, try (with or without the amount field)

select [date], amount from table1
Union
select [date], amount from table2

To show all occurences, also duplicates, use Union All in stead of
Union