Dragonous24
New member
- Local time
- Today, 12:20
- Joined
- Feb 6, 2020
- Messages
- 15
so i have a Crosstab Query [qryTraining-Crosstab] to track who has done what courses.
the column headings are Course Names..... course 1, course 2, course 3, etc
the row headings are the people name [Fname] .... jim, john, jane, etc...
and the values are there course status [fld_Name_stat] ..... passed, failed, booked
with help i got the Crosstab query on to a form. So far so good.
What i want is a field that has a "pass" count for each course.
i tried something like:
but it always returns 0.
i must have the dcount setup wrong, but dont know how to correct.
the column headings are Course Names..... course 1, course 2, course 3, etc
the row headings are the people name [Fname] .... jim, john, jane, etc...
and the values are there course status [fld_Name_stat] ..... passed, failed, booked
with help i got the Crosstab query on to a form. So far so good.
What i want is a field that has a "pass" count for each course.
i tried something like:
Code:
passcount = dcount("course 1","qryTraining-Crosstab","fld_Name_stat=Pass")
i must have the dcount setup wrong, but dont know how to correct.