Hi,

I have a little problem using the IIf. What I would like to have is that on a continuous form a count operation is performed.
If for exemple I'm using a 'time' field to count on, what I would like is that it counts the data if the fields value is before 14:00 and return 0 if no record has a time before 14:00. So if I have 3 fields before 14:00 (like 12:10 and 13:25 and 13:59) it has to return 3.

If I would have the fields 12:10 and 13:25 and 13:59 and 14:10 it should return 3. If i would only have 14:10 and 14:55 it has to return 0.

Does anyone knows how I have to do this? Everything I try fails...

thanks

You can make the continuous form a subform of another, and on that other add a text box. Assuming the record source for the continuous form is a query named 'qry', the data source for the text box should be:

SELECT(COUNT(*) FROM qry WHERE field < #14:00#)

The way the time's formatted may need to be fixed, I've not used time in a query before.