Picking Blank Fields

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

Hendrix10

I have an existing table that I have been updating with dates of when
I receive documents. I would like to create a query that would give
all the records with no information in the date received field. Is
that possible? If so, How would I do it?
 
Use a select query with criteria for the date field as Null assuming that the
date field is DateTime datatype.
 
Add crtieria of Is Null under the date received field in the query.

Field: DateReceived
Criteria: Is Null



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Use a select query with criteria for the date field as Null assuming that the
date field is DateTime datatype.
--
KARL DEWEY
Build a little - Test a little





- Show quoted text -
Click to expand...

Thanks those worked
 
Back
Top