I think this is on the right track. I am trying to drop the redundancy in the report. My goal is:
300415 = TRUE
300697 = TRUE
301220 = FALSE
If there is 1 FALSE then they are all false. This report is something I am running once per week. It is keying FALSE if a date of a PO has been changed when it is being pulled from QuickBooks. If the date changed then I want it to say FALSE so I can then go back and see how many POs have been changed. This way I can then evaluate how many POs are never changed vs changed.
I think this is getting very close to what I need I just don't know how to drop all of the POs into 1 number field and have it = FALSE if it = FALSE even 1 time...
Bookmarks