query problem in report - repost

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a report that is running from a query. The fields in the
query include 5 date text boxes from a form. These date text boxes relate to
5 other name text boxes that are also included in the query. I only want
these names and dates to show up on my report when the date text box is null.
So, in my query, I have put "is null" in the criteria field. The problem is
that if there is a date in only 1 of the date text boxes in the form (but the
other date text boxes are null, so they should show up on the report),
nothing from that form is showing up on the report. If all 5 date text boxes
are null, they all show up. What am I doing wrong? Thanks.
 
Putting all the "Null" criteria on the same line means "AND"; that is only
when A and B and C are null does the record appear. To get the record to show
when A or B or C is null, stagger the "Null" entries - each on a separate
line.

Not this:

null null null

But this:


null
null
null
 
That makes sense, but each text box is in a separate column. The first "Is
Null" is under the 'Criteria' row. Where do I put the others? I tries
putting them in the blank rows below 'criteria', but that didn't work.

Didn't work:
Null
Null
Null
Null
Null

thanks.
 
My last post didn't appear the same way I typed it. I had staggered the
"Null's". Perhaps that what you did, also. Do I put them under the 'or' row
or the blank rows under that in my query?
 
One IsNull goes under Field1, one under Field2, one under Field3, etc.
BUT...each IsNull goes on a different line in the criteria section (the
additional blanks below "or" are just more "or"s), so it looks like this:

Field: Field1 Field2 Field3
Table:
Sort:
Show:
Criteria: IsNull
or: IsNull
IsNull
 
Back
Top