Query with Null Fields

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
 
R

Rick B

Place the following criteria under each column...

Like [Enter Text To Search] &"*"

Rick B
 
V

Van T. Dinh

(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)
 
Top