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

I have already tried the grouping function but that does not seem to be
doing anything. I have also tried changing the data source to no avail.

Thank you for your help!
 
Here's an example I have used:

I have a true/false field called [Contributor]
I wanted to count the number of items where this field is true for my
report.
I created a field called [CountContributor] and put it on the detail line,
invisible.
ControlSource: =IIf([Contributor]=True,1,0)
Running Sum: Over All
At the foot of the report I have a field to show this number:
ControlSource: ="Number of Contributors: " & [CountContributor]

I am thinking you could have a field where the ControlSource is something
like:
=IIf([Y] = [C] AND [A] = ,1,0)

using the same principles.
HTH
Mich
 
Back
Top