Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-11-2019, 12:36 PM   #1
billgyrotech
Banned
 
Join Date: Apr 2013
Posts: 258
Thanks: 67
Thanked 3 Times in 3 Posts
billgyrotech is an unknown quantity at this point
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


Last edited by billgyrotech; 08-05-2019 at 02:10 AM.
billgyrotech is offline   Reply With Quote
Old 07-11-2019, 01:08 PM   #2
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,130
Thanks: 0
Thanked 502 Times in 498 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: AFR Report Return to Service

=IIf([Disposition] IN("Inspected/Tested","Overhauled","Modified","Repaired"), "Approve", "Disapprove")
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is online now   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
billgyrotech (07-11-2019)
Old 07-11-2019, 02:02 PM   #3
billgyrotech
Banned
 
Join Date: Apr 2013
Posts: 258
Thanks: 67
Thanked 3 Times in 3 Posts
billgyrotech is an unknown quantity at this point
Re: AFR Report Return to Service

Thank you June!

billgyrotech is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Return web service SomeITGuy Forms 5 05-11-2012 12:13 AM
Sending Access Report via Networked Fax Service tokoloshi Modules & VBA 2 09-08-2008 03:41 PM
How to return cleanly from report with no data to report menu collizz Reports 7 03-30-2006 02:08 AM
If a report return no results paulmcdonnell Reports 2 07-26-2004 01:26 AM
Having difficulty with querying service data for a report vangogh228 Queries 2 07-29-2002 04:00 PM




All times are GMT -8. The time now is 02:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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