Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Carolinec said:
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?
Click to expand...

Something like

SELECT rating_description, COUNT(*) AS tally
FROM [Booking Process]
GROUP BY rating_description;

Jamie.

--
 
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.
Click to expand...

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