Need help with DCOUNT in reports

  • Thread starter Thread starter JustMe
  • Start date Start date
J

JustMe

Hi All - I have a deadline for tomorrow and have no clue how to do the
following.

I have set up reports for a bunch of different fields using the DCOUNT =
'value' string.

Now, I need to do the exact same thing when another field in another
table equals a certain value.

In other words, I need to have the report display the following:
There are X number of times where Y equals Z when A equals D

so far, I have only been able to get :
There are X number of times where Y equals Z

Thank you for your help!
 
so far, I have only been able to get
There are X number of times where Y equals
If you have managed to do the above then use the AND operato
where Y equals Z AND A equals
 
Jim said:
If you have managed to do the above then use the AND operator
where Y equals Z AND A equals D

Ya - I tried that...It only added them together.
 

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

Need help with DCOUNT in reports 1
Access Dcount (multiple criteria) 3
Adding Blank Lines to a Report 0
Dcount the values 0
Report Calculation 0
very slow report with dcount() 6
Count/Dcount and Group Header 4
Excel Need Countifs Formula Help 0

Back
Top