Query Criteria Too Strict (way too strict!!!) (2003)

Topic

New Reply

Hello Again…

In my company’s database…which keeps architectural info & conditions for a homeowners’ association…I need to run queries from time to time…that do not have a strict criteria definition.

My inspector in the field, for example, enters info on ‘Satellite Dishes’…but there will always be different circumstances as to condition…meaning that the entered language always differs.

So…Access queries won’t show results unless the specific phrase is found.

I need to be able to loosen up those criteria boundaries. I want to be able to run a query; & specify say, “Satellite Dish” as the criteria…& then get results on every entry that has the words ‘satellite dish’ mentioned in the records. Can this be done???

Thanks,

mark4man
Access 2003

Reply | Quote

Replies

If you enter

Like "*satellite dish*"

in the criteria line, all records where the field contains satellite dish will be returned, i.e. the following values will all qualify:

Big satellite dish
Satellite dishes
20 satellite dishes and more
Blue satellite dishcloths

but not

lite dishes

Does that do what you want?

Reply | Quote

Hans…

That works !!!

Thanks very much,

mark4man

Reply | Quote