Query with Null Fields

  • Thread starter Thread starter Keith Ward
  • Start date Start date
K

Keith Ward

Hi,

My database has two fields for description. Webdescritpion and
cataloguedewcription.

The may or may not be a description in either field so it could be filled or
be null.

I want a query that will search for a word in either field and return the
record if its there, but if there is no criteria given then all the records
are return.

How do I construct the where clause for the null fields?
Thanks

Keith
 
Place the following criteria under each column...

Like [Enter Text To Search] &"*"

Rick B
 
(The last 2 paragraphs of your post ask for 2 different queries. I am
guessing you meant the 2nd last paragraph).

Use the criteria:

WHERE
([WebDesc] Like "*" & [Search Word] & "*") OR
([CatDesc] Like "*" & [Search Word] & "*") OR
([Search Word] Is Null)
 
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

Is Null 2
field Null but not Null 9
Table with fields with no data 4
NOT function not working - can prove with screenshots 1
Return ALL records with NZ function 4
Query based on Check Box 1
Parameter Query With Null Values 3
Query Criteria 1

Back
Top