Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi, Is this Syntax correct?? =I

Status
Not open for further replies.
nike2000

nike2000

Technical User
Apr 1, 2003
61
GB
Hi,
Is this Syntax correct??

=IIf([PV_OverTolerance]="No","Yes",IIf([DeltaOverTolerance]="No","Yes","No"))

Thanks for looking,
Nike
 
Sort by date Sort by votes
Yes...if this is what you want: If PV=no then the field will be &quot;Yes&quot;...if pv<>no and delta=no then the field will be &quot;Yes&quot;, otherwise the field will be &quot;No&quot;.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JohnXr
  • Locked
  • Question
thread703-757058 I use the followi
Replies
4
Views
437
Axworthy
Axworthy
breezett93
  • Locked
  • Question
Sending report via email only works when Outlook is closed
Replies
1
Views
424
breezett93
breezett93
breezett93
  • Locked
  • Question
Text cut off even though the text box is large enough
Replies
16
Views
1K
strongm
strongm
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
409
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
555
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top