Query criteria to return records with null value in field?

S

Star Taylor

I'm trying to figure out the criteria where the results will be those records
with no value in the End_Init, End_Date, and End_Time fields. Several
attempts are not yielding the correct results.

User enters start time and date, etc. when a job is kicked off. Completion
of this job may run into another shift. The incoming shift will run a query
to locate those records with no value so they can enter the job's completion
date, time, and their initials.

Any help is greatly appreciated!

Thanks!

Star
 
M

Michel Walsh

In the grid, you can type

Is Null


under the column (End_init, as example). That assumes that the column is
NOT of a string data type allowing 0 character string. In that case, you may
have to also check about a zero length string of character. There should be
no problem for numerical data type fields.


Hoping it may help,
Vanderghast, Access MVP
 
Top