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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kevvan
-
Supply Null value in IIF statement as a condition response
I meant dhookom - sorry bout that.- kevvan
- Post #7
- Forum: Microsoft: Access Queries and JET SQL
-
Supply Null value in IIF statement as a condition response
It took a while but I found the answer...in a microsoft Q article: http://support.microsoft.com/kb/304428/EN-US/ It involves using a combination of the Like Operator and the FORMS parameter. The answer is this: Like ([Forms]![Form1]![txtbox1]="blah", "*", [Forms]![Form1]![txtbox1]) If the...- kevvan
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Supply Null value in IIF statement as a condition response
Sorry, I think I stated this wrong. When I say that I want to have a blank criteria, I mean I'd want to replace/remove the criteria [Forms]![Form1]![txtbox1] that exists in the query so it won't filter anything. There's no way for me to do that programmatically. That means that...- kevvan
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Supply Null value in IIF statement as a condition response
I have a form that calls a query and passes a textbox value to be evaluated in an IIF statement. The textbox value default value is the word blah. The IIF statement looks something like this: IIF ([Forms]![Form1]![txtbox1]="blah", NULL, [Forms]![Form1]![txtbox1]) The logic is that if the...- kevvan
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
