Recent content by Alinchains

  1. A

    IIf statement query issue

    That is great. I will do some testing on this and see. I am sorry about being vague on the rules since there are 6 possible results for each of the 3 fields so there are a number of possible outcomes. If I can get an idea then I can build it as I go and update when a difference scenario comes...
  2. A

    IIf statement query issue

    That is the trick. I have to account for all the different possible situations. If a process is done daily then it probably should be monitored frequently. So a monitor of daily and a control of daily would be best case but you could also take it out a out bit and say if the process is done...
  3. A

    IIf statement query issue

    Thank you. I have attached a very simplified version of this. In the last field is the result of the Pass/Fail. Yes, huge Chains fan!
  4. A

    IIf statement query issue

    Hello group. I have a table I need to have an update done to and I am struggling to get it to work. I have a table named AU-ARCM Details. There are 3 fields. [Activity AU Frequency] [Control AU Frequency] [Monitoring Tool AU Frequency] Each field has a frequency of Daily, Monthly, Quarterly...
Top Bottom