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

Need some PWA help 0
MS Project. Real progress of the project, % complete 1
Page numbering with Merged Document and IF statements 1
IIf statement 9
Cumulative formula for word table 0
IIf statement 4
IIF Statement 2
IIf works in query but not in report 1

Top