Chronological order of Two different date fileds?

  • Thread starter Thread starter Conrad
  • Start date Start date
C

Conrad

Hello,

I am trying to create a report that will sort my performances and rehearsals
chronologically.
I have two tables; Rehearsals and Performances. Each table has it's own date
field.
When I am designing my query that pulls all the info required including the
Two Date fields from these tables, how do I order the data so that my
rehearsals and performances show up chronologically.
Example:
RehearsalDate Jan 01
RehearsalDate Jan 05
PerformDate Jan 06
RehearsalDate Jan 08
PerformDate Jan 09

Can this be done with two date fields each from a different table?
I am completely at a loss!
Thanks for any help
 
Conrad

Take a look at Access HELP for a "UNION" query. Generically, you are
getting a list from two different sources and combining it into one list.

This would allow you to combine similar/like information from two tables.

Regards

Jeff Boyce
<Office/Access MVP>
 
You cna easily do this using a union Query. Here is a dumed down example!

Select "RehersalDate", RehersalDate from Rehearsals
Union
Select "PerformDate", PerformDate from Performances
Order by RehersalDate

-
Ron W
www.WorksRite.com
 
Back
Top