conditional "count" calculation

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I am working on a booking form. I need to count how many
places are booked or provisionally booked on a particular
course. I have used the "count" function and have got how
many entries are against that course, but I need to put a
condition on it and only count those records where the
status is "booked" or "provisional". What function do I
use?
 
Back
Top