Search results

Hi, I need to create a query to produce a report showing 'how busy the pool is over a typical week'. In my tblPool: Column 1: Pool_Ticket, e.g. a0001 Column 2: Ticket_Type, e.g. MP or NP, MP = member of the gym and NP = non-member of the gym. Column 3: Member_ID Column 4: Time_Pool = the...

Where would you place the sample data?

Hi, I would like to create a query which produces a report at the end. In the report I would like to know 'how far in advance are members booking the badminton court' and 'how far in advance are non-members booking the badminton court' In my tblBadmintonCourtBooking: Column 1: Booking_ID...