Dcount issue once again.

[dynamite9585]

Once more i am having trouble wrapping my head around Dcount.

I have a survey, the results are stored in TblSurveyClients.
i have a field in there called location, one result is Tokoroa
I am trying to make a form to track how many people have responded from each town.
i have an unbound box i am trying to use
DCount([tblSurveyClients]![Location],[tblSurveyClients]![Location],"=tokoroa")
have also tried using Dcount("*",[tblSurveyClients]![Location],"=tokoroa" and various other combinations.

any help is much appreciated.

Thanks

 

[Catalina]

Does this work:

=Dcount("Location" , "tblSurveyClients" , "Location= 'Tokoroa'")


Catalina

 

[Catalina]

You may also want to check this page:

http://www.techonthenet.com/access/functions/domain/dlookup.php

 

[dynamite9585]

Swapped out dlookup to dcount and worked a treat thanks.
seems it doesn't like having the [] on them

 

[Catalina]

Great, I noticed my mistake and changed it.

Glad it works.

Catalina