Search results

Sorry, it does work. I mistyped, thank you very much.

What do you mean by adding a "value" to each query?

I tried what you told me to do but it comes up with the error message 'the specified field 'Full_Name' could refer to more than one table listed in the FROM clause of your SQL statement'.

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

Thank you, much appreciated.

Correction: The first query is this: SELECT Count(*) AS Count_Member_Gym FROM tblGym WHERE (((tblGym.Ticket_Type)='MG')) AND (((tblGym.Date_Gym) Between '02/01/12' And '04/01/12')); The second query is this: SELECT Count(*) AS Count_Nonmember_Gym FROM tblGym WHERE...

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

I have done it now, thank you very much. Much appreciated.

I understand what you're saying but how would I place an option group on the form with 5 radio buttons? For the personal level feedback, I would haven't to add anything or do anything if I added an option group on the form with 5 radio buttons, right? Thanks.

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

I've set up the tables and tried setting up the query and no luck. I've done everything apart from the query that I require now, that's why I posted a question in this forum, to ask for help. The table is listed at the top...

I'm a novice user so it'll be hard for me to carry out the queries I want. I can produce basic queries but not the ones I require.

Thank you so much for the help, really appreciated.

I would also like to be able to see whether weekdays are busier or weekends. So from Monday to Friday or Saturday and Sunday.

I would like to be able to see the total number of pool users for a typical week and to distinguish between members and non-members. Ignore the morning, afternoon and evening query. Thanks.

E.g. the number of members or non-members who have used the pool in a typical week and whether it's busier in the morning, the afternoon or the evening. Also, Time_Pool = the time the member or non-member used the pool (i.e. 4:23 pm).

How would you include the average SQL statement with the min and max SQL statement? I want the whole query to produce the min, max and the average and represented in a report. Thanks.

Can you have a maximum and a minimum rather than an average?