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

"AND" statement within an "iif" statement

Status
Not open for further replies.
GaborH

GaborH

Technical User
Nov 5, 2003
48
US
Can someone be kind enough to give me a hint as how I can incorporate an "and" statement withing the criteria of an "iif" statement?

Thank you!
 
Sort by date Sort by votes
Hi GaborH,

Have you tried the obvious ...

Code: 
[blue]IIF([Field1] = "Value1" AND [Field2] = "VAlue2",True,False)[/blue]
?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
442
Axworthy
Axworthy
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
719
BJZeak
BJZeak
iamchemist
  • Locked
  • Question
"Access Application Not Responding" Message
Replies
1
Views
237
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
DeRochier
  • Locked
  • Question
Subform triggers error: "This expression is typed incorrectly..."
Replies
3
Views
491
DeRochier
DeRochier

Part and Inventory Search

Sponsor

Back
Top