Dcount the values

Aug 5, 2011
Reaction score

What the best way to perform Dcounts on groups in an Access report.

For example, I have 3 MOH that are in four regions either MOH East, MOH West, MOH Central and Other Region. I have a query called qryNotifablesbyAreaALL that shows a history of all the lab that have been assigned to their regions. On my report I want a total for each lab reports bases on how many are assigned to the four regions

This is what I know of the Dcount function but the result I get (obviously) is the TOTAL number of the 'Responsibility Coverage at the end of each group.

Here is the text box I placed in the 'Responsibility Coverage footer:
="Summary for " & "'Responsibility Coverage' = " & " " & [Responsibility Coverage] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"

Can anyone please help me with the syntax to Dcount the values for each MOH and not the entire total? I know that the reason the total value is being returned is because I am Dcount'ing the entire qryNotifablesbyAreaALL query. How am i able to Dcount each MOH region in the Group Footer?

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
Count or DCount used in a report 1
Get Sums for 2 DCount fields on report 1
Access MS Access DCount function problem 0
DCount 9
dcount syntax 1
DCount in Reports 5