Multiple conditional null query (1 Viewer)

J

JMichaelM

Registered User.
Local time
Today, 06:01
Joined
Aug 4, 2016
Messages
101
I forget how to do this query. If i have multiple fields which are not null then i want to result in specific text.

Field 2 null
Field 3 null
Field 4 null
Result A

Field 2 null
Field 3 null
Field 4 not null
""
 
isladogs

isladogs

MVP / VIP
Local time
Today, 14:01
Joined
Jan 14, 2017
Messages
18,209
I'm sure your field names aren't as listed. What are they really?

Also what's the name of the table and the field to be updated?
 
J

JMichaelM

Registered User.
Local time
Today, 06:01
Joined
Aug 4, 2016
Messages
101
Its gonna be something like:

IIF ([Valid] Is Not Null and IIF ([Expired] Is Not Null, "Ok" , ""))

All have to be null for one result.
 
P

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:01
Joined
Feb 19, 2002
Messages
43,223
There is no need to use IIF(). This is a queyr and the "If" is implied in the Where clause.

@JMichaelM,
If you figured out the answer or someone else provided it, then the generous thing would be to post the solution here so that someone else might find it.
 
You must log in or register to reply here.

Similar threads

N
Solved Query date or is null not working
Replies
2
Views
358
Number11
N
A
Show only Null Records
Replies
10
Views
556
Pat Hartman
P
N
Solved How to convert "" to null in MS Access VBA
2
Replies
22
Views
350
NauticalGent
NauticalGent
D
Problem with IIF statement and filtering a query
Replies
4
Views
558
Pat Hartman
P
N
Solved How to convert an access delete query to Passthrough query
Replies
5
Views
180
nector
N

Users who are viewing this thread

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