QUERY to show record if text present in field

Y

yorkielover02

I have a query that I would like for it to only show a record if there is
something (text/anything) present in that field. Any ideas on how to do that
would be appreciated.
 
P

PieterLinden via AccessMonster.com

yorkielover02 said:
I have a query that I would like for it to only show a record if there is
something (text/anything) present in that field. Any ideas on how to do that
would be appreciated.
Click to expand...

WHERE [SomeField] IS NOT NULL
 
M

Marshall Barton

yorkielover02 said:
I have a query that I would like for it to only show a record if there is
something (text/anything) present in that field. Any ideas on how to do that
would be appreciated.
Click to expand...


Set that field's criteria to Is Not Null
 
Top