I've generated a query using the query builder in Access and it has generater the following: -
Expand|Select|Wrap|Line Numbers
- SELECT tblBooking.Booking_Date, tblBooking.Booking_Type, tblBooking_Time_Slot.Booking_Time_Slot, tblEmployee.Employee_Name
- FROM tblEmployee INNER JOIN (tblBooking INNER JOIN (tblBooking_Time_Slot INNER JOIN tblBooking_Slot ON tblBooking_Time_Slot.Booking_Time_Slot_ID = tblBooking_Slot.Booking_Time_Slot_ID) ON tblBooking.Booking_ID = tblBooking_Slot.Booking_ID) ON tblEmployee.Employee_ID = tblBooking.Employee_ID;
What I'm trying to do is return only one line for each record and show the MAX and MIN booking time for each particular Booking_ID
i.e.
15/10/2007 Reservation 10:00 (MIN time) 13:00 (Max time) Mark Smith
rather than at present
i.e.
15/10/2007 Reservation 10:00 Mark Smith
15/10/2007 Reservation 11:00 Mark Smith
15/10/2007 Reservation 12:00 Mark Smith
I realise that I prpbably need to use a GROUP BY statement and a MIN & MAX to return the correct times, but I'm having great difficulty in doing so.
Any help would be very much appreciated.
Thanks