Search results

Start again, I have a list of Players who are all eligable to attend a class (stored in table Player). I have a table Class which holds the instance of the class. Whenever a class run (Monday, Tuesday ...) I want to produce a complete list of the children with a tick box next to their name. If...

namliam, Thanks for the support on this. I am not there though. If I do as you say then Player Fred will not appear on class 3 if they attended class 2. The reason being that [Player Attendence].Class = 2 not null. What I am trying to acheive is every class wiping the slate clean and creating a...

You are correct. However, to my mind using a left outer join should bring back all rows in the left table (Players) even where they do not exist in the right hand table. this works with the first query but not when I complicate with a sub-query. Maybe I should step back to my requirement. i...

If only! The query I posted gives me all the Players by virtue of the left out join. When I complicate the query to: SELECT Player.FirstName, Player.LastName, [Player Attendence].Attended, Player.[Class Type], [Player Attendence].Class FROM Player LEFT JOIN [Player Attendence] ON...

Hello, I have a very simple database for recording attendence to classes Table 'Player' PlayerID AutoNumber FirstName Text LastName Text ... Table 'Class' Class AutoNumber Date Date/Time Table 'Player Attendence' PlayerAttendence AutoNumber Attended Yes/No Class Number Player Number...