I cannot get the DCount function to work as advertised?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a group header and footer that is grouping my report
correctly. Within this group, I have a field I want to count. I can count the
total number of entries in this field (a year field that contains data such
as 2002, 2003, 2004, 2005). Now I need to count only those records that are
2005. I have tried changing the field in the table from number to text and
using the DCount but still doesn't work. Thanks.
 
It would help to know what you've tried (i.e.: show us your code), as well
as details about what's wrong (Are you getting the wrong count or are you
getting an error? If an error, what's the error?)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access Dcount function in access 0
DCount within a Group 2
Access MS Access DCount function problem 0
DCount 4
DCount help 1
dcount 1
Dcount question 6

Back
Top