Dcount operation

[DontKnow]

Hi Guys,

Using the DCOUNT function I am receiving a n error!!

strsql = DCount("[UserID]", "Exam", "[correct] = 'yes'")

What am I doing wrong!! It is being used for the number of fields that have
a Yes in the yes/no field. The error that IO receive is:

Data type mismatch in the criteria expression.

I can make this work when I use another field but I want to count the number
of correct entries for a user??

Any help greatly appreciated!!

Cheers,

 

[tbs]

it should be:
DCount("1", "Exam", "[correct] = true")

 

[John W. Vinson]

Hi Guys,

Using the DCOUNT function I am receiving a n error!!

strsql = DCount("[UserID]", "Exam", "[correct] = 'yes'")

What am I doing wrong!! It is being used for the number of fields that have
a Yes in the yes/no field. The error that IO receive is:

Data type mismatch in the criteria expression.

I can make this work when I use another field but I want to count the number
of correct entries for a user??

Any help greatly appreciated!!

Cheers,

A Yes/No field isn't a text string; it's actually stored as a number, -1 for
Yes, 0 for No. It will never be equal to the text string 'yes'.

Since it's either TRUE or FALSE, and a criterion evaluates to either TRUE
(retrieve the record) or FALSE (don't), all you really need is

DCount("[UserID]", "Exam", "[Correct]")

although for readability you could also use the builtin constant True (not
'True' or "True", just the word True):

DCount("[UserID]", "Exam", "[Correct]=True")