Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   [SOLVED] AFR Report Return to Service (https://www.access-programmers.co.uk/forums/showthread.php?t=305835)

billgyrotech 07-11-2019 12:36 PM

AFR Report Return to Service
 
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

June7 07-11-2019 01:08 PM

Re: AFR Report Return to Service
 
=IIf([Disposition] IN("Inspected/Tested","Overhauled","Modified","Repaired"), "Approve", "Disapprove")

billgyrotech 07-11-2019 02:02 PM

Re: AFR Report Return to Service
 
Thank you June!


All times are GMT -8. The time now is 08:03 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World