Access DCount

  • Thread starter Thread starter Frank Locraft
  • Start date Start date
F

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'")
 
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.
 
Back
Top