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
 

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

Paste Link and Link Text From Browser to Word 0
Dynamic Naming of Form Button 3
How do I freeze the swimlane headers? 0
Outlook linking to non default browser Edge 0
How to insert HTML into an Outlook 2021 email 0
Autonumber field in Excel that behaves the same as Access 0
Word doc keeps changing to ALL CAPS 0
Finding the right style field in VBA 0

Top