DCount always = 0 1

[KayJen]

I have a form called Interview. When I enter a social security number in the text box named SSAN, I would like for an adjacent unbound text box currently named SSAN_TST to count how many times the social security number appears in the database. I have a query named CountSSN which counts the SSN in the query and gives me what I am looking for, however, when I use DCount in the Form I always get 0.

My DCount Syntax is:

=DCount("SSAN","CountSSN","Where SSN = '" &Forms!Interview!SSAN & "'"

Any help as to where I have messed up would be greatly appreciated.

Thanks,
Sonny

 

[Junior1544]

try this...
=DCount("SSAN","CountSSN","Where SSN = Forms!Interview!SSAN"

Just a thought
--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[PWise]

you are going no-->where<--
in a dcount you dont need the word where
=DCount(&quot;SSAN&quot;,&quot;CountSSN&quot;,&quot;SSN =&quot; & Forms!Interview!SSAN)
1) what is the name of the field in the query is it ssan or ssn?
2)if the field is a text field you need
=DCount(&quot;SSAN&quot;,&quot;CountSSN&quot;,&quot;SSN ='&quot; & Forms!Interview!SSAN & &quot;'&quot

 

[KayJen]

Thank both of you for your quick reply, the field was text and the solutions worked, exactly like I wanted and just the way you say it would, again, Thank You Both...

Sonny