AFR Report Return to Service (1 Viewer)

Hello,


Hold down shift key when opening database.


On the 'AFR' report there is a statement:


I 'text field' THIS PART FOR RETURN TO SERVICE IN ACCORDANCE WITH FAR 43.9 AND / OR 43.11


How can the text field have the word "APPROVE" if the 'Disposition' field is one of these:


Inspected/Tested
Overhauled
Modified
Repaired


Or if the 'Disposition' field is any other then make the text field be "DISAPPROVE"


Thank you in advance for your help,
Bill

=IIf([Disposition] IN("Inspected/Tested","Overhauled","Modified","Repaired"), "Approve", "Disapprove")

Thank you June!