conditional "count" calculation

[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?

 

[Gerald Stanley]

A good place to start would be DCount.

Hope That Helps
Gerald Stanley MCSD

 

[lynn atkinson]

Not sure how to use this function. Any ideas where I can
find examples?

 

[Art]

Type in DCount in the search box of Access Help

Hope This Helps