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!

Standard SQL for IIf

Status
Not open for further replies.
SteveNapper

SteveNapper

Technical User
Aug 29, 2002
39
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
Filtering for null or empty field
Replies
8
Views
1K
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Looking for a color chart 1
Replies
2
Views
313
BallunarCrew
BallunarCrew
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
626
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
kingz2000
  • Locked
  • Question
Bound/unbound forms
Replies
2
Views
671
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top