loop or not?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there I have four fields on my form:
Cat 1 Score
Cat 2 Score
Cat 3 Score
Cat 4 Score

Current, if cat1 = 100 then it passes, otherwise it fails. THis is the case
for cat 2, 3 and 4. I need to account for null values because some
establishments don't have a value for a particular category.

At present i am using a series of if statements. Is there a more efficient
way?

Regards,
 
I figured it out. Thanks for your time.

As for the code it was a series of if statements for each fields before
update event. If the criteria was met, then the score passed, otherwise it
failed. If no score was entered, then there was not pass of fail entered and
the field was not used in the decision to pass the entire record.

Again, thanks for your time.
 
Back
Top