Merge data from multiple queries with like fields

[twinspar]

I have created four simple queries from multiple tables. These queries
contain essentially three fields each; source table, posting date, and cost.
I need to merge the data into a single query where a single date field will
contain all dates found in the underlying queries, and each record will
display the appropriate source table and cost. Is there a simple way to
accomplish this?

 

[KARL DEWEY]

Use a UNION query.

Very odd to have a field containing 'source table.'

 

[twinspar]

Thanks, Karl. I'll try the UNION query. FYI: I used an expression to populate
a table name in each of these preliminary queries to indicate the source
table. The intent was to be able to identify, after merge, where source data
(date, cost) originate.