I'm building a small database for a school to help maintain their Music Lessons. These lessons take place over 3 days but all the different lessons happen at once on each day. So a member can only be down for 1 Session "day". Though its possible on the table at the moment for a member to be saved for 2+ lessons which take place on the same day.
I'm in need of having a Query where I can see if members have been assigned to the same Session more than once.
I'm fairly new to SQL, and I'm having to use MS ACCESS due to the School but it shouldn't matter.
I feel the best way Would be to have a query for each Session, and for it to just read out the names of who are down for more than 1 of that Session.
The names etc. of all the members are saved on one table and there is a second table which matches the member to a Lesson and states the Session.
Last Feeble Attempt:
I've tried many ways I feel could work, but to no avail, this is my last try I'm getting tired and frustrated so this is probably retarded.
SELECT [Member Workshops].Member
FROM [Member Workshops]
HAVING (COUNT(Session = Session 2) > 2);
This is all for Work Experience placement from Uni and have been taught very little when it comes to even simple mixing of Functions. So apologies if I seem very knowledgeable, because I am.
P.S: I made the "Member" and "Session" both primary keys in the table I linked above which makes what this whole query wants to check impossible to happen, but I'm being told to do it any way -.-'