Sum fields if values of another fill equals specific value?


D

david.isaacks

I have a report with three fields. [Facility] [Month] [Count]

The month field either equals "February" or "March". I want to have a
text box that sums the Count field only if the Month Field equals
"February".

Any ideas?

Dave
 
Ad

Advertisements

N

NetworkTrade

base your report on a query

and then in the criteria of the calc field you can do an Iif function based
on the string value of the month field....
 
Ad

Advertisements

Joined
Aug 24, 2014
Messages
1
Reaction score
0
Could you be more specific, please

base your report on a query
and then in the criteria of the calc field you can do an Iif function based
on the string value of the month field....
 

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

Top