translate IIFs in a where clause to CASE statements

no wonder I omitted the single quotation mark '0'

all makes sense now.Very well spotted .


Thanks very much
 
You must log in or register to reply here.

Similar threads

D
Problem with IIF statement and filtering a query
Replies
4
Views
906
Pat Hartman
P
S
Complex T-SQL Statement Conversion to MySQL
Replies
14
Views
918
stanhook
S
N
Solved Progress meter for reports & queries in MS Access
Replies
16
Views
790
tvanstiphout
T
N
Solved Caching recordset in MS Access VBA
2
Replies
26
Views
1,757
tvanstiphout
T
N
Solved Count iif in a query
Replies
2
Views
528
nirmal
N

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom