[AccessD] Dcount dates

Jack and Pat drawbridgej at sympatico.ca
Tue May 11 14:23:08 CDT 2010


Bob, Here is an example from my data that works

?DCount("[Case ID]","CaseAssign","[Opened Date] Between #8/8/2009# and
#9/20/2009#")

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: Tuesday, May 11, 2010 3: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
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.819 / Virus Database: 271.1.1/2866 - Release Date: 05/11/10
02:26:00





More information about the AccessD mailing list