[AccessD] Dcount dates

Where Year([Date Signed]) = 2010 and Month([Date Signed]) = 2

or

Where Format([Date Signed],"mmmyyyy") = "Feb2010"

Doug

On Tue, May 11, 2010 at 12:11 PM, Bob Heygood <bheygood at abestsystems.com>wrote:

> 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
>