Re: Dcount Month Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
http://mvp.support.microsoft.com/

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

"Andy Paris" <puzzu123@xxxxxxxxx> wrote in message
news:exMFXK9JIHA.5624@xxxxxxxxxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: Different data shown based on user input
    ... The correct tick boxes were showing this time. ... --check only one check box and observe that the other checkboxes are ... The basic process is to build the query using the fields that have been ... Dim strStub as String ...
    (microsoft.public.access.queries)
  • Re: Check boxes in a Word form
    ... Consider using checkboxes instead of tick boxes. ... Microsoft's Legal Users' Guide) http://addbalance.com/usersguide ... This message is posted to a newsgroup. ...
    (microsoft.public.word.docmanagement)
  • Re: How do you create a checkbox in a column?
    ... Design a form for data entry. ... > rearrange the information to sequentially match how we currently work on ... In rearranging the columns with checkboxes, ... > it would be as simple as doing the old copy/paste method. ...
    (microsoft.public.access.gettingstarted)
  • Re: Making check boxes active on selection of radio button...
    ... > Hi yall ... > I have a form for entry to an event ... Hi Mark, I can help you on this as I am a bit of an expert in ... Make the 5 and all its checkboxes an image with greyed out ...
    (alt.html)
  • Re: listView question
    ... Is it possible to have a listview with checkboxes that allows the user ... and vice-versa ie check a box without selecting that entry. ... sure if there is one) ie if both called then call the checkedbox event ...
    (microsoft.public.dotnet.languages.csharp)