blank fields

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

 

[Rick B]

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.

 

[Terry]

I figured it out. I put like "*" in the criteria and it
pulls only records with a value in that field.

 

[Terry]

Thanks for the reply, Rick.