Hey Mark, I'm getting the error that I can not use the <> operator with numbers or text.
Also, I am using one Field for each graded question, so I am not sure how to manipulate what I am trying to do with your solution.
For example, I will pretend I have the three questions:
Wall Cleanliness: (1-10 numeric grade)
Floor Cleanliness: (1-10 numeric grade)
Window Cleanliness: (1-10 numeric grade)
Normally, I'd take the three grades and average them for the overall 'cleanliness' score. But if the next location I go to does not have windows, I would need to omit that from the overall average of the 'cleanliness' score.
------------------------------
Michael Martin
------------------------------