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

IIF statement in criteria line

Status
Not open for further replies.
Scoob55k

Scoob55k

Technical User
Nov 16, 2005
62
US
I have a query that I want to use an IIF statement return either specific data or all records depending on a text box value on a form.

Basically the statemet reads as such:

=IIf([Forms]![frm Reports by Type]![TaskType]="All",Null,[Forms]![frm Reports by Type]![TaskType])

It works fine as with a certain Task Type selected, but left as "ALL" it returns nothing. I've tried "" and 0 before I did the Null, but ended up the same result. Thanks!
 
Sort by date Sort by votes
Code: 
=[Forms]![frm Reports by Type]![TaskType] OR 
 [Forms]![frm Reports by Type]![TaskType]="All"
 
Upvote 0 Downvote
Sweet! For some reason I do not think I would have ever figured that out. Way too simple.

Thanks!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
1K
Swi
Swi
C
  • Locked
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
466
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
722
mikrom
mikrom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
5K
combo
combo

Part and Inventory Search

Sponsor

Back
Top