Here is what I am struggling with. I have a database where I need multiple If statements. but here is an example of what I am trying to do.
If [Activity AU Frequency] = "Monthly" and [Control AU Frequency] = "Annual or less" and [Monitoring Tool AU Frequency] = "Annual or less" then "Fail"
If [Activity AU Frequency] = "Daily" and [Control AU Frequency] = "Monthly" and [Monitoring Tool AU Frequency] = "quarterly" then "Pass"
And so on for each possible scenario.