Filtering Criteria Question

[Don]

In my query, I have a field called "LAST_DATE". It is formated as a date,
mm/dd/yy.

I'm looking to display only one certain date. In the criteria field, I
entered that date in the following format without success: #mm/dd/yy#

Additionally, I wan to be able to show or exclude those records where the
date is not entered. How do I write the criteria for an emply date field?

Your help is greatly appreciated.

 

[Golfinray]

try Like 10/1/2005 or Like 10/01/05, however you have your dates set up. You
can also do Between 2/2/2009 and Now() or Between 2/2/2009 and 2/3/2009.

 

[Don]

Thank you. I discovered my own stupidity after I made my post. I had
entered the filtering criteria without success; however, I finally remembered
I had three rows of criteria on 3 other columns and when I added the three
rows of date filters, the query worked.