Parameter query, null value in (table) field

[Guest]

I have a parameter query with many criteria, such as ' Like [Forms]![Find
person]![Title] & "*" '
I though it was working fine until I discovered that it only returned
records where there existed values in the tables for field with criteria.
So in the criteria above, if the record did not include a 'Title' then the
query would omit that record in the output.
There are 6 or 7 criteria so it gets pretty messy in the WHERE scenario!
I do not have any 'Is Null' statements.
Any help appreciated as always!

 

[Tom Ellison]

Dear Graeme:

For this, you may want:

WHERE (SomeColumn = Like [Forms]![Find person]![Title] & "*"
OR SomeColumn IS NULL)

Having the parens I put in will be important if there are other criteria to
be met.

Tom Ellison