translate IIFs in a where clause to CASE statements (1 Viewer)

M

Mittle

Member
Local time
Today, 05:48
Joined
Dec 2, 2020
Messages
105
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
612
Pat Hartman
P
N
Solved Progress meter for reports & queries in MS Access
Replies
16
Views
299
tvanstiphout
T
N
Caching recordset in MS Access VBA
Replies
0
Views
178
nector
N
N
Solved Count iif in a query
Replies
2
Views
430
nirmal
N
S
Hi. I am new to this group and I am not a profesional. I am 66 years old and a retired Bank Officer active with Retired Bank Officers community.
Replies
8
Views
324
Suresh1957
S

Users who are viewing this thread

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