Null & Is Not Null Query Question

R

Randy

I have a query with 3 fields of [EmployeeID], [FirstDay] and [LastDay]
(Firstday and LastDay are date fields) I am trying to get my query to give
the results of the Missing dates for both the Firstday and Lastday. Some
employees may have the firstday or the lastday missing or both. I have been
experimenting with Is Null and Is not null or both in the criteria giving
partial results. If I put Is null in the Firstday criteria only, I do get a
list of employees missing the Firstday dates. If I also put Is Null in the
Lastday criteria, All I get is employees with only the Firstday and the
lastday dates missing, but not employees with either/or the firstday and
lastday missing. Please help..Randy
 
D

Douglas J. Steele

I assume you're trying to do this in the query grid. When you put conditions
on the same row, you AND them together. If you put them on separate rows,
you OR them (which is what you want)
 
R

Randy

Thanks, that was what i needed.
Douglas J. Steele said:
I assume you're trying to do this in the query grid. When you put
conditions on the same row, you AND them together. If you put them on
separate rows, you OR them (which is what you want)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Randy said:
I have a query with 3 fields of [EmployeeID], [FirstDay] and [LastDay]
(Firstday and LastDay are date fields) I am trying to get my query to
give the results of the Missing dates for both the Firstday and Lastday.
Some employees may have the firstday or the lastday missing or both. I
have been experimenting with Is Null and Is not null or both in the
criteria giving partial results. If I put Is null in the Firstday
criteria only, I do get a list of employees missing the Firstday dates.
If I also put Is Null in the Lastday criteria, All I get is employees with
only the Firstday and the lastday dates missing, but not employees with
either/or the firstday and lastday missing. Please help..Randy
Click to expand...
Click to expand...
 
Top