Query Command

[HOCSMGR]

Working with a query that shows items checked out, i believe I figured out
how to show just the items for 2007 through 08. However I am having trouble
with showing them items that are blank with no check out date/time.

I am currently just using a Between #01/01/2007# and #01/01/2009#

I figured this will give me all records. However its not giving me the items
not checked out which is what I really need to see. How would I show all
items 2007 though 2008 plus the items without a checkout time/date?

 

[KC]

Can you not add a or is null in the date parameter ?

 

[John W. Vinson]

I figured this will give me all records. However its not giving me the items
not checked out which is what I really need to see. How would I show all
items 2007 though 2008 plus the items without a checkout time/date?

Between #01/01/2007# and #01/01/2009# OR IS NULL

as a criterion on the checkoutdate field.


John W. Vinson [MVP]