Recent content by RickyBeast

Thank you very much. That did the trick. I do not understand why however.

ok, another try: T_STUDENTS studentsID STUD_coach RES_vrijstelling STUD_year 1 Ricky False 2 2 Ricky False 1 3 Sally False 2 4 Sally True 2 5 Gwen False 1 6 Gwen True 1 7 Ricky False 3...

thank you. Here is what i have and what i want it to do; my table T_STUDENTS contains information about a student STUD_vrijstelling = a yes/no field STUD_year = a list of options; 1,2,3,A or G STUD_coach = a name that is taken from another table table T_COACHING contains the number of ours...

Hello, thank you for your reply. I will explain more elaborately. I have a main form with 5 subforms. Each of the subforms runs a query similar to the code i posted above, but using different fields from T_STUDENTS and T_COACHING. When one of the queries finds no matches the subform...

Hello, I am quite new to access and especially have trouble understanding and dealing with null. I have the following code SELECT Count(T_STUDENTS.studentsID) AS res1yes, T_COACHING.COACH1res, T_COACHING.COACH1port, T_COACHING.COACHworkgroup FROM T_STUDENTS, T_COACHING WHERE...