Access DCount

[Frank Locraft]

I'm having a problem with the "DCount" function on my
version of Access. Is the Access Help function Providing
the correct syntax?
=DCount("variable to Count]", "Table to count
from", "where variable = '1'")

 

[Allen Browne]

To count all the records in the table that match the 3rd argument,
just use "*" for the first argument:

=DCount("*", "Table to count from", "variable = 1")

Note that you should not include the quote marks in the 3rd argument unless
the field "variable" is of type Text.