On Wed, 28 Jan 2009 20:00:04 -0800, Deb H
wrote:

=DCount("[VisitNumber]","[tblClient Visits]","[Client Nb]=" &
[Forms]![frmVolClientName]![Client Nb] & " And [Date of
Visit]#12/31/2008#")
DCount takes three strings. The third one is a concatenation of
several elements.

-Tom.
Microsoft Access MVP


I have an unbound text box on a form in which I want to show the number of
visits in 2009 for the client number displayed in the form. I can't seem to
get the syntax right. Here is my control source:

=DCount("[VisitNumber]","[tblClient Visits]","[Client Nb]=" &
[Forms]![frmVolClientName]![Client Nb] And [Date of Visit]#12/31/2008#")

Thanks for your help.