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

Standard SQL for IIf

Status
Not open for further replies.
SteveNapper

SteveNapper

Technical User
Joined
Aug 29, 2002
Messages
39
Location
GB
Anyone know an answer to the above?
 
Sort by date Sort by votes
Hi!

You can use the IIf function in SQL, at least in the field definition:

NewfieldName: IIf(YourCondition, ifTrue, ifFalse)

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
Hi again!

One more thing, what I have above is used in the query design view, in SQL view use:

IIf(YourCondition, ifTrue, ifFalse) As NewFieldName

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TechieJr
  • Locked
  • Question Question
Filtering for null or empty field
Replies
8
Views
2K
dhookom
dhookom
BallunarCrew
  • Locked
  • Question Question
Looking for a color chart
Replies
2
Views
476
BallunarCrew
BallunarCrew
TrekBiker
  • Locked
  • Question Question
This is the source query for what
Replies
12
Views
909
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
kingz2000
  • Locked
  • Question Question
Bound/unbound forms
Replies
2
Views
900
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top