View Single Post
  #1  
Old January 29th, 2009, 04:00 AM posted to microsoft.public.access.forms
Deb H
external usenet poster
 
Posts: 9
Default Multiple Criteria in a DCount

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.