Please help with DCount Function

[yanniper]

Hi

​

I need to count all fields with the status in the form base on Query with input value

​

For example "=DCount("[Status]","[MainQ]","[Status]=Work")" but I get an error message

​

What is the Problem with this syntax

​

For example Please see the attachment file , Type in the input box "ben" or "David" and click OK

​

Thank You

 

[pbaldy]

I haven't looked at the sample, but your syntax is off for a text value:

http://www.mvps.org/access/general/gen0018.htm

 

[vbaInet]

=DCount("*","[MainQ]","[Status]=[B][COLOR=Red]'[/COLOR][/B]Work[COLOR=Red][B]'[/B][/COLOR]")

 

[yanniper]

Thank you​

But the syntax doesn't work in my case, it work only if I change the Criteria in the Query from​

Like [name] & "*"[FONT=&quot]
[/FONT]​

to

"ben" for example

 

[Poppa Smurf]

I used vbaInet code and it worked in your database. I have attached your database for you to check.

 

[yanniper]

Hi

I don't see the vbaInet code, the form show all records without input value for filter​

 

[Poppa Smurf]

You will get all the records in my example as I removed the criteria for the user. You will need to somehow include the [name] in the dcount so that you can count on Status = Work AND Users = a selected user etc.