Need help with DCOUNT in reports

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!
 
J

Jim

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
 
J

JustMe

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