Search results

Hi, I have 2 queries which I would like to join together, I have tried for hours but I cannot seem to get it to work. The first query is: SELECT tblMember.Member_ID,Count(Gym_TicketNo) AS n_Gym FROM tblMember LEFT OUTER JOIN tblGym ON tblMember.Member_ID=tblGym.Member_ID GROUP BY...

Hi, at the moment I have this query: SELECT Feedback, Exercise_Class_ID, Count(*) AS Total_Per_Exercise_Instructor FROM tblExerciseClass WHERE (((tblExerciseClass.Feedback) Between '0' And '1')) AND (((tblExerciseClass.Date_Exercise_Class) Between '02/01/12' And '03/01/12')) GROUP BY Feedback...

Hi, I would like to combine 2 queries together but I don't know how to, I've tried for hours, it seems very simple but I cannot do it. This is the first query: SELECT Count(*) AS Count_Member_Gym FROM tblGym WHERE Ticket_Type='MG'; This is the second query: SELECT Count(*) AS...

Hi, I need to perform a query to produce a report, I have to answer this question 'who is the favourite class instructor this month?' In my tblExerciseClass: Column 1: Exercise_Class_No Column 2: Exercise_Class_ID = each exercise class has an Instructor_ID and each exercise instructor teaches...

Hi, in my frmExerciseClass I need to be able to allow members or non-members to provide feedback for an exercise class they have taken part in or provide no feedback at all. I need to be able to store it either at a class level (X% positive feedback) or at a person level (John Smith chooses to...

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...

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...