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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If statements

Status
Not open for further replies.
ptrifile

ptrifile

Technical User
Aug 10, 2004
457
US
I am trying to do something i thought was extremely simply but I cant seem to get it to work.

I have about 12 fields on a report that all either have a value of 1, 0 or Blank.

If the value of the field is 1 I want another text box to read "YES", if it is 0 i want it to be "No" and if it is blank i would like it to be "N/A"

Can someone give me any tips?

Thanks

Paul
 
Sort by date Sort by votes
I have resolved my problem. I was not using the IIF statement properly. Thanks anyways!!

Paul
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
479
renigar
renigar
rubberhead10
  • Locked
  • Question
query if any value = x
Replies
3
Views
79
rubberhead10
rubberhead10
ptrifile
  • Locked
  • Question
If NULL then N/A 1
Replies
2
Views
60
ptrifile
ptrifile
Triacona
  • Locked
  • Question
count(iif,iif,value) is this and if? if so how do I do or if
Replies
2
Views
103
Triacona
Triacona
egstatus
  • Locked
  • Question
How to tell if a report uses sub reports? 1
Replies
3
Views
66
egstatus
egstatus

Part and Inventory Search

Sponsor

Back
Top