View Full Version : Count All Blank Fields in Form


TClark14
12-19-2001, 07:25 PM
I have a form based on a query that looks like this:

Client Session1 Session2 Session3
Doe,John 12/1/01 12/7/01
Smith, S 12/19/01
Mouse, M 12/5/01 12/12/01

I need to add an unbound (I think) field to Count the number of sessions remaining (Blanks) resulting in a total of 4 per the sample. Or a field to count each individually resulting in 1, 2, 1 which could be added together for a total.

Can someone tell me how I can acheive this?

Thanks
Terry