Date listing: too many dates!

[rickyoswald]

I have several actions and the times they were carried out stored on several tables. I need to list all actions in a report ordered by date, my problem being there are several date fields relating to only their own table. What I need is to have one list of dates which for each day can call up several actions each from seperate tables.

 

[Schroeder]

Sounds like you need to look into using a Union query.

 

[rickyoswald]

I moved all the relevant fields from the different tables into one large table, then sorted this by date. Thanks anyway.