IIF statement question

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
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?
 
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.
 
I got "Brain Freeze" and couldn't retract post. Sorry it has been a very
long day!
 
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
string together IIf statements into one text box? 3
Access Building a IIF expression in Access 0
IIF Statement 2
IIF statement 2
Conditional DB reports 3
IIF Statement 2
Iif Statement with Null Values 2

Back
Top