Usage help please... (1 Viewer)

How do you calculate usage? For example...
If I've got a field named Time, then a drop-down box with "Morning", "Afternoon" and "Evening"
How do I make a query so it displays the number of each time...
For example...

There's two times for Morning, three for afternoon and one for evening.

I tried using the 'Sum' total and the criteria of "Morning" but it says data mismatch. That was merely a guess, so I would like to know how to do it.

Like...

Time

Morning: Afternoon: Evening:
2 3 1


Thanks.

Try with COUNT instead of SUM.

When I select the booking type (occasional or regular) and in criteria I put "occasional", it says data mismatch expression. Booking type is a drop-down box if that helps. Also, how would I calculate the percentage usage of occasional bookings? Say there are a total of 20 bookings, and 10 of which are occasional (other 10 are regular). How would I calculate the percentage usage of occasional (ie 50%).