Calculation

[Carolinec]

I have a field that records whether our [Booking Process] is Very Good, Good,
Satisfactory, Poor or Very Poor.
How do I run a report which shows on the one report, the number of Very
Goods, Goods, etc? ie how do I get it to sum them all? I thought this would
have been easy but it has turned out not to be quite so! Any help, much
appreciated.

 

[fredg]

I have a field that records whether our [Booking Process] is Very Good, Good,
Satisfactory, Poor or Very Poor.
How do I run a report which shows on the one report, the number of Very
Goods, Goods, etc? ie how do I get it to sum them all? I thought this would
have been easy but it has turned out not to be quite so! Any help, much
appreciated.

The value in [Booking Process] is stored as Text datatype?

If you have controls on the report that display the [Booking Process]
data, then add an unbound control for each of the 5 possible values:

=Sum(IIf[Booking Process] = "Very Good",1,0)
=Sum(IIf[Booking Process] = "Good",1,0)
etc.

Simpler (but perhaps a bit more confusing) would be:
=ABS(Sum([Booking Process] = "Very Good"))
etc.