making a report based on two date fields so that its in chronological order

[bennybee]

I have two seperate queries base don tables which give the following results.:

Meeting_Query (based on meeting table) -
Meeting_Date Location Type
11/11/03 Darwin Monthly Meeting
17/12/03 Alice Monthly Meeting

and

Hearing_Query (Based on Hearing table) -
Hearing_Date Location Type
11/11/04 Darwin Hearing
16/03/04 Darwin Hearing

Hearings are based on the agenda items of a particular meeting.
so a meeting has an agenda which may go to a hearing

now i want to be able to have another query (so that i can make a report based on it), which will display the information in the following way:
Date Location Type
11/11/03 Darwin Monthly Meeting
17/12/03 Darwin Monthly Meeting
16/03/04 Darwin Hearing
11/11/04 Darwin Hearing

i want the query to sort the data by the date fields. so that they are in chronological order. so that the report generated can be circulated to commission members.

is there a way that i can do this - so that each record is displayed and they are in date order.

when i have tried this, it sometimes associates the meeting with the hearing (as they are linked through the meeting_agenda. that is a meeting has agenda items, and a hearing is then based on an agenda item), but i want each entry to be seperate, so that this report can be formed.

is this possible?

 

[Pat Hartman]

Sorting a report is controlled by the report's sorting and grouping properties rather than by the order by in the query.