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

Signature
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
> Hi.
>
[quoted text clipped - 4 lines]
> Can someone help me please.
> Thanks a lot