Query criteria to return records with null value in field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Access Dcount (multiple criteria) 3
Criteria to return all records if selection from form is null 3
counting Null fields 3
Return only records with empty field 1
Query Criteria Not Working 2
Query to duplicate a record with one field updated 0
Query to find records after specific date and time today 10
Use In() Expression as Query criteria with guts from Function 1

Back
Top