Using DCount with Long integer

[Dominaz]

Hello!
I'm having problems Using Dcount function, when I use it with a text field like the following it works fine: (but using a Surname as a criteria can have problems.... I've people with the same surname in my database...)

times = DCount("[Surname]", "Booktoscore", "[Surname] = Forms!Teachers!Surname.value")


But, If I try to use it with a number, then it doesn't work, the problem seems to be with the criteria.... Because Access don't show me any msgbox with errors....

times = DCount("[IdCandidate]", "Booktoscore", "[IdCandidate] = Forms!Teachers!IdCandidate.Value")


Thank you very much!!!

[jzwp11]

With the DCount() function you can use the * wildcard instead of a specific field since you are just counting records. The main issue with your expression is that the form references a variable and thus cannot be contained within the double quotes

times = DCount("[Surname]", "Booktoscore", "[Surname] =" & Forms!Teachers!Surname.value)

OR

times = DCount("*", "Booktoscore", "[Surname] =" & Forms!Teachers!Surname.value)

[Dominaz]

Hello¡ Thanks for your help, but I think you didn´t understand me,

When I use :

times = DCount("[Surname]", "Booktoscore", "[Surname] = Forms!Teachers!Surname.value")

It works. (Surnname is a text)

BUT when I try to use:

times = DCount("[IdCandidate]", "Booktoscore", "[IdCandidate] = Forms!Teachers!IdCandidate.Value")

It doesn´t works... IdCandidate is a number....

Thanks again

[jzwp11]

The reference to the form (no matter what field type) must no be included within the double quotes.



Sorry, I did forgot to delimit the text field. Text fields must be delimited by single quotes and if the value is a variable like your form reference it must not be in the double quotes. Note the single quotes in blue and the placement of the double quotes and the &'s

times = DCount("*", "Booktoscore", "[Surname] ='" & Forms!Teachers!Surname.value & "'")


Numeric fields do not have to be delimited but the form reference still has to be outside the double quotes and connected to the string with an &

times = DCount("*", "Booktoscore", "[IdCandidate] =" & Forms!Teachers!IdCandidate)

Also if you are counting you can use the * wildcard in place of the field since the Dcount just counts records irrespective of the field.

[Dominaz]

Thank very much. Now It works !!

[jzwp11]

You're welcome