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