loop or not?

[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,

 

[AlCamp]

Carlee,

At present i am using a series of if statements.

Care to share that code with us??
Al Camp

 

[Guest]

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.