Interactive Query not working

[gkluther]

I built a query that queried 4 fields for "Is Not Null". They were OR'd
so that a hit in any would result in that record being selected. I then
went back and added an interactive date selection capability. My date
selection looks like this:

[Enter Start Date] And <=[Enter End Date]

That seems to be working kinda but with the 4 fields that are OR'd it
makes the date thingy look like it is not working. What I think is
happening is that the OR'd fields are getting a hit for a record that
has a date outside the range. I think what I need to do is group (but I
don't know how) the 4 fields that are OR'd and then AND the group with
the date selection. If someone could tell me how to do that I would
appreciate it.

One more small item. I set the properties for the interactive date
query above for Medium Date in both the format and the mask. When I run
the query the mask is not showing up. Not a clue what needs to be done
here. Any clues for me?? Thanks, I appreciate the time you experts
take to get us novices up to speed.

 

[Rick B]

Just put the date criteria on the same row as EACH of the or statements.

So you have...


X is not null AND date is between start and end
OR
Y is not null AND date is between start and end
OR
Z is not null AND...


--
Rick B

I built a query that queried 4 fields for "Is Not Null". They were OR'd
so that a hit in any would result in that record being selected. I then
went back and added an interactive date selection capability. My date
selection looks like this:

[Enter Start Date] And <=[Enter End Date]

That seems to be working kinda but with the 4 fields that are OR'd it
makes the date thingy look like it is not working. What I think is
happening is that the OR'd fields are getting a hit for a record that
has a date outside the range. I think what I need to do is group (but I
don't know how) the 4 fields that are OR'd and then AND the group with
the date selection. If someone could tell me how to do that I would
appreciate it.

One more small item. I set the properties for the interactive date
query above for Medium Date in both the format and the mask. When I run
the query the mask is not showing up. Not a clue what needs to be done
here. Any clues for me?? Thanks, I appreciate the time you experts
take to get us novices up to speed.