Running Access 07'
Building a QA database and my form has 5 fields, each with 2 values (Pass & Fail)
I would like to have a form automatically fill in a 6th field with a pass or fail value based on the other five. If none of the 5 are fails then it will report a passed audit, if one or more of the 5 categories are fails than it will report a fail.
I know I can throw in the field for our auditors to complete, but I'd rather have it do it automatically as a fail safe.
Can I do this?