blank fields

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Hi all
I'm very new to access and have a question for someone. I
set up a query with several fields and I want to set the
criteria so if a certain field (say the date field) is
blank I don't want to pull that record. How can I do
this? I hope I explained this correctly. Thank you.
 
put something like the following in that column's criteria...

Is Not Null




Rick b


Hi all
I'm very new to access and have a question for someone. I
set up a query with several fields and I want to set the
criteria so if a certain field (say the date field) is
blank I don't want to pull that record. How can I do
this? I hope I explained this correctly. Thank you.
 
I figured it out. I put like "*" in the criteria and it
pulls only records with a value in that field.
 
Back
Top