Optimised query

  • Thread starter Thread starter Keith Emery
  • Start date Start date
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)?
 
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.
 
Understood. How does the Access logic work then - does it
do a complete data search on criteria rather than running
one after the other?
 
Keith

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

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