Picking Blank Fields

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?
 
K

KARL DEWEY

Use a select query with criteria for the date field as Null assuming that the
date field is DateTime datatype.
 
J

John Spencer

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
..
 
H

Hendrix10

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
 
Top