Problem with count function

[RJL1]

I have a report thatlists all of the open orders from previous days. One of the field in the report is ship_carrier. I would like to add a breakdown of how many of each different type of carrier the report includes. I can get the overall total but not the total for each specific carrier. Iget the overall total by using =Count([ship_carrier]) in the report footer. Is there a way that I can count the total of each different carrier. For example total for UPS Ground

Thanks in advance
Ricardo

 

[PaulBricker]

Use the DCount method.
=DCount("ship_carrier","UnderlyingQueryNameHere","ShipperName = 'UPS'&quot

 

[RJL1]

It Works It Works

Thanks
Ricardo

 

[Monzer]

Never mind Paul it works Thank you very much,you really helped me.

Thanks a lot.