Dcount Month Help

[Andy Paris]

Hi.

I have a table which conatains DATE of Entry and Tick Box. I need to
DCOUNT those tick boxes which are yes for the month of January from the
field date of entry.

Can someone help me please.
Thanks a lot

 

[Jeff Boyce]

Andy

You posted your question in the "forms" newsgroup, but ask about your
"table".

If this were mine, I'd create a query to count (i.e., add) the checkboxes
where Month([DateOfEntry]) = 1.

If you have to count checkboxes = True, try using DSUM() instead. Take a
look in Access HELP for the exact syntax ... you should be able to use that
Month() function inside DSUM().

Note: you may also need to use the Abs() function to get the absolute value
of the "sum" of the checkboxes -- Access stores a "True" as -1.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/