Using DCOUNT in Access with multiple criteria
Hi,
I have a database that tracks pupil progress with different subjects which are rated at different levels . I have a Y/N filed which indicates if the subject has been passed. I have this written in the footer of the form
=DCount("PupilID","S2 List","PupilID=" & [PupilID] & " AND Pass= TRUE" AND " LCode=3 ")
If I run it with
=DCount("PupilID","S2 List","PupilID=" & [PupilID] & " AND Pass= TRUE" )
It tells me how many subjects have been passed but if I add the bit that asks for those subjects with level (LCode) 3 that have been passed it just counts all the records my guess is i have some quotes in wrong place but cannot work it out ...
Any help appreciated.
I have a database that tracks pupil progress with different subjects which are rated at different levels . I have a Y/N filed which indicates if the subject has been passed. I have this written in the footer of the form
=DCount("PupilID","S2 List","PupilID=" & [PupilID] & " AND Pass= TRUE" AND " LCode=3 ")
If I run it with
=DCount("PupilID","S2 List","PupilID=" & [PupilID] & " AND Pass= TRUE" )
It tells me how many subjects have been passed but if I add the bit that asks for those subjects with level (LCode) 3 that have been passed it just counts all the records my guess is i have some quotes in wrong place but cannot work it out ...
Any help appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER