[AccessD] Dcount dates

Bob,

If you will be selecting the year and month required via controls 
(listboxes?) on a form, then something like this...

"[Date Signed] Between 
DateSerial([Forms]![YourForm]![YearSelected],[Forms]![YourForm]![MonthSelected],1) 
And 
DateSerial([Forms]![YourForm]![YearSelected],[Forms]![YourForm]![MonthSelected]+1,0)"

Regards
Steve


--------------------------------------------------
From: "Bob Heygood" <bheygood at abestsystems.com>
Sent: Wednesday, May 12, 2010 7:11 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Dcount dates

> Hello to the list,
>
> I am trying to supply a value to an unbound text box on a report.
> The following works fine:
>
> =DCount("ParticipantsID","tblParticipants")
>
> But I need to have the criteria set to where the field "Date Signed", is
> during a certain month. Say all who signed during Feb 2010.
>
> I can't seem to do this. I tried some variations using Between and #s, am
> brain dead now.
>
> Tia
>
> Bob Heygood