Filter question

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a column that is a date field. I need to produce a
report that shows all records that DO NOT have dates
entered in that field. How can I do a filter that will
filter out dates? I have tried running queries with the
criteria being "IsNull" or "Null" - these have not worked.
Help!?! Thanks in advance!
 
Actually thinking about it Is Null works
make sure you have a space in between the Is and the Null
 
You must log in or register to reply here.

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

Trouble with Code for date filter on report... 9
Date search query 0
FILTER ANNULS SORT ORDER? 5
MS Access query filter problem 1
Filter subform from combo unbound text box 3
query on blank or range 1
Expert advice needed 11
Problem with date criteria in Query 2

Back
Top