Multiple Queries with date fields into one list

[seirra]

I have a 5 different queries tracking different items, All have expiry dates. What I would like to do is some sort of query (or something) that will give me a single ordered column of these dates. When i try to bring them into one query I obviously have multiple columns

I have no idea what this is called or even if there is a name for it. But any help would be greatly appreciated.

 

[Norie]

Without further information the only thing I can think of would be a UNION query.

Mind you, why do you have 5 different queries anyway?

 

[seirra]

Thanks for the reply, I will look into a UNION query and see how it works.

I should have stated that it is a multi table database with multiple queries. The dates are coming from more then one source table.

Thanks

 

[Norie]

So you can't combine the tables?