[AccessD] Dcount dates

"[Date Signed] >= #" & datBeginningOfMonth & "# AND [Date Signed] <= #" &
datEndOfMonth & "#" 

Doesn't work?.  Is the problem getting the beginning and end of month into
the variables?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Tuesday, May 11, 2010 12:11 PM
To: 'Access Developers discussion and problem solving'
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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com