Hello,
I'm trying to make a simple Customer Meeting Travel Itinerary database. I've attached a screenshot of the relationships to get an idea. It's pretty simple where you create meeting, flight, hotel, taxi dates and times. The form with the subform is working very well.
The problem I'm having is putting it all in a report and trying to Group/Sort the report by dates and times from different tables. I would like the report to group by day of the week (Starting on the first day of earliest event) and sort those days by the date time of the events.
The events days times from different tables are meeting date and time, flight date and time, hotel date and check in time, etc.
Is it possible to put it all this together in one report?
I'm trying to make a simple Customer Meeting Travel Itinerary database. I've attached a screenshot of the relationships to get an idea. It's pretty simple where you create meeting, flight, hotel, taxi dates and times. The form with the subform is working very well.
The problem I'm having is putting it all in a report and trying to Group/Sort the report by dates and times from different tables. I would like the report to group by day of the week (Starting on the first day of earliest event) and sort those days by the date time of the events.
The events days times from different tables are meeting date and time, flight date and time, hotel date and check in time, etc.
Is it possible to put it all this together in one report?