Return only records with empty field

[Pamela]

I want to create a report to track open assignments. My thought was to
create a completed date control on my form and run a report showing all
records that have an empty completed date control. Created a query but am
not figuring out what Criteria to use for "empty" (I tried =Null but it
didn't work).

Also, because this is a new process, I would like to date stamp the
assignments of when first entered into my form so that I can narrow the
criteria by date (so not to pull OLD records that don't have these fields
completed) The Now() operator seems to pull current date/time -- not time
first started..

How can I do this?? Thanks so much! ~ Pamela

 

[PieterLinden via AccessMonster.com]

I want to create a report to track open assignments. My thought was to
create a completed date control on my form and run a report showing all
records that have an empty completed date control. Created a query but am
not figuring out what Criteria to use for "empty" (I tried =Null but it
didn't work).

Wrong syntax. Use: [Date Completed] IS NULL

Also, because this is a new process, I would like to date stamp the
assignments of when first entered into my form so that I can narrow the
criteria by date (so not to pull OLD records that don't have these fields
completed) The Now() operator seems to pull current date/time -- not time
first started..

How can I do this?? Thanks so much! ~ Pamela

if you want to capture the date/time the records were entered, add another
field to your table and set the default value to NOW()

 

[John Spencer]

If you want just the current date to be entered, set the field's default to
=Date()

If you want the Date and Time set the default to
=Now()

If you want just the Time set the default to
=Time()

To check for absence of a value in a field, the criterion is
Is Null

To check for the presence of a value in a field, the criterion is
Is NOT Null


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

I want to create a report to track open assignments. My thought was to
create a completed date control on my form and run a report showing all
records that have an empty completed date control. Created a query but am
not figuring out what Criteria to use for "empty" (I tried =Null but it
didn't work).

Wrong syntax. Use: [Date Completed] IS NULL

Also, because this is a new process, I would like to date stamp the
assignments of when first entered into my form so that I can narrow the
criteria by date (so not to pull OLD records that don't have these fields
completed) The Now() operator seems to pull current date/time -- not time
first started..

How can I do this?? Thanks so much! ~ Pamela

if you want to capture the date/time the records were entered, add another
field to your table and set the default value to NOW()