Optimised query

K

Keith Emery

I have a report querying a table. It runs very fast with
normal selection criteria. However, i now need to further
select, searching for a word in a text field,
unfortunaltely.

The query now runs like a dog. I know that text searches
are rubbish but can I not make it search for the first set
of criteria and then the text (in the same query run)?
 
J

Jeff Boyce

Keith

One approach would be to use more than one query. In your first query, use
your selection criteria to "zero in" on a smaller number of rows. Build a
second query, based on the first, that does the text search.
 
K

Keith Emery

Understood. How does the Access logic work then - does it
do a complete data search on criteria rather than running
one after the other?
 
J

Jeff Boyce

Keith

I don't pretend to know the innards of Access.

Will knowing make a difference doing it accomplishes what you are after?
 
Top