IIF statement question

T

TotallyConfused

How do I write an IIF statement if I want to exclude rows where there are
dates. There are 3 date fields. If one of the date fields is Not Blank then
do not print report. If all fields are Null then print report. Would a
simple "IsNull" in each field in my query suffice?
 
D

Duane Hookom

Seems to me it would take less time to test "Would a simple "IsNull" in each
field in my query suffice?" than to post a question.

If you can't test this on your own, reply back.
 
T

TotallyConfused

I got "Brain Freeze" and couldn't retract post. Sorry it has been a very
long day!
 
E

Evi

Actually, I can really understand this; I've had that, where I've been
totally stumped by something until the moment I press Send and then see my
message as if it came from someone else!

Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIf statement 9
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
IIF Statement 2
Address box with IIf Statement 7
IIF statement help 13
IIF Statement 2
IIF statement 2
Iif Statement with Null Values 2

Top