Count non-blank fields in form

  • Thread starter Thread starter Ian
  • Start date Start date
I

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
 
Ian said:
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?
Click to expand...

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.
 
Back
Top