RickyBeast
New member
- Local time
- Today, 07:29
- Joined
- Aug 11, 2015
- Messages
- 5
Hello,
I am quite new to access and especially have trouble understanding and dealing with null.
I have the following code
it runs fine, untill the moment the count is 0. At that point it breaks the form.
How can i tell access to deal with this? Somehow i need to replace the count result with 0 if there are no records that meet the criteria.
I am quite new to access and especially have trouble understanding and dealing with null.
I have the following code
Code:
SELECT Count(T_STUDENTS.studentsID) AS res1yes, T_COACHING.COACH1res, T_COACHING.COACH1port, T_COACHING.COACHworkgroup
FROM T_STUDENTS, T_COACHING
WHERE (((T_STUDENTS.res_vrijstelling)=False) And ((T_STUDENTS.stud_year)="1") And ((T_STUDENTS.stud_coach)=forms!F_cboCOACHING!cboCOACHING))
GROUP BY T_COACHING.COACH1res, T_COACHING.COACH1port, T_COACHING.COACHworkgroup;
How can i tell access to deal with this? Somehow i need to replace the count result with 0 if there are no records that meet the criteria.