Query only returns fraction of applicable entries

[sephiroth2906]

Hello all!



I have a query that is designed to look at several fields and return results via a form with unbound text boxes. It uses criteria on each field that use variations of

Like "*" & [Forms]![Search]![txtName] & "*"

One of the fields is a date field, one a currency field, one is a number field and 5 short text fields

Right now the database has over 14,000 entries. If I run the query with no values, I get 2727 consistently. When I add values, I am getting really spotty results. There are a whole bunch of entries the query is not returning regardless of what values are entered and which are not.

Is this sort of query inappropriate for what I am looking for? Is there some sort of time out value I can change? Should I be using a SQL or VBA solution instead? Any guidance that can be offered will be much appreciated!

Thanks for your time!

[June7]

Do all records have values in every one of these fields? The LIKE and wildcard is designed to work that situation is the case. If records have Null, they will be ignored. Maybe you need to deal with Nulls. One way:

Like "*" & [Forms]![Search]![txtName] & "*" Or Is Null

[sephiroth2906]

Yup! That did it! The users have null fields that should not be null, so that is a whole other issue. There are a few fields that are going to be changed to require input in the near future I believe.

Thank you so much for the help!