Query Question!

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

If I have a Query that shows all my records but I only want the Query to
show the record that has no data/Blank in [OwnerID]
Thanks for any help......Bob
 
Open the query in design mode
in the [OwnerID] field enter ISNULL as it's criteria.
Close and Save
 
You must log in or register to reply here.

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

Query Expression Help! 26
Why wont my query Show Owner Name 3
Can this be done? 3
Find Missing Records in a table 1
Filter a Listbox 27
Overdue Query help needed 3
Query, Change Expression if True 1
Add One Condition! 3

Back
Top