Report: Count of one field if another is a certain value problem!

[Pusscat]

Hi,
I have a data report with say 5 columns of data fields A- E.

There are 6 rows of data.

A___B___C ___D ___E
1__ MS__ ___ 5__10
2 __XX__0___20___5
3 __MS__0___0 ___20
4__ XX__0___20___5
5 __MS__ ___15___10
6__ MS__0___20___5

I want to be able to have a count under each field column C, D and E but only count the number on entries for each where the field B is 'MS' and not XX.

I've been trying to combine Count and iif statements but I'm getting in a complete mess...can anyone uggest a formula I can use for the report please?!

Much appreciated in advance,
Pusscat.

 

[Trevor G]

Try using a DSUM formula or even a DCOUNT look at this link to get you started

http://www.techonthenet.com/access/functions/domain/dsum.php

http://www.techonthenet.com/access/functions/domain/dcount.php