Count non-blank fields in form

[Ian]

I have a form with 7 date fields representing the date a
participant attends a course. I would like to count how
many courses the participant attends by counting how many
date fields contain a value. Am I going about this the
right way?

Thanks

 

[Mike Painter]

I have a form with 7 date fields representing the date a
participant attends a course. I would like to count how
many courses the participant attends by counting how many
date fields contain a value. Am I going about this the
right way?

No. There should be a separate table that contains the student ID, The
course ID and the date.
That makes it trivial to count the number and allows a student to take more
than seven courses.

 

[Ian]

Thanks very much Mike, that sounds like a much better way
to go, I'll try it out.

Ian