what criteria will select a blank in a date/time field?

G

Guest

I have a table with a field (date.time) showing sales dates. I am trying to
write a query that selects the records that have a blank in this field. The
operator Is Null creates a data type mismatch response. What criteria
expression will select the blanks in the Sales Date field? I am using XP
Office access program.
 
D

Duane Hookom

A criteria of
Is Null
will work with all data types. Are you sure your criteria doesn't have
quotes around it?
 

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

Criteria for select query. 2
How to retrieve dates that meets a criteria using Query? Exp Build 1
Date/Time criteria problem 2
Date Expressions/Criteria 1
Help with expression builder in a Query to retrieve wanted dates 2
Help with expression builder in a select Query 2
Use a function in the "Criteria" of a query? 3
Date criteria problem 16

Top