DCount syntax

[JethroUK©]

i'm trying to count how many records ([ID]'s) in the table (Clients) have
the same [Start Date] as the one on the form - but i get a #Name error ?

=DCount("[id]","clients","[start date]= " & [me].[Start_Date])

also tried

=DCount("[id]","clients","clients![start date]= '" & [me].[Start_Date] "'")

 

[Ken Snell [MVP]]

Is this an expression for a control source of a textbox? If yes, drop the
"me" reference.

Also, you need to delimit the date value with # characters:

=DCount("[id]","clients","[start date]= #" & [Start_Date] & "#")

 

[JethroUK©]

i never thought about the # signs - thanks very much

Is this an expression for a control source of a textbox? If yes, drop the
"me" reference.

Also, you need to delimit the date value with # characters:

=DCount("[id]","clients","[start date]= #" & [Start_Date] & "#")

--

Ken Snell
<MS ACCESS MVP>

i'm trying to count how many records ([ID]'s) in the table (Clients) have
the same [Start Date] as the one on the form - but i get a #Name error ?

=DCount("[id]","clients","[start date]= " & [me].[Start_Date])

also tried

=DCount("[id]","clients","clients![start date]= '" & [me].[Start_Date]
"'")