Robin Davis wrote:

>
> Sorry, the 2nd index didn't help, but I've discovered something bizarre! If
> I do the search as "Start of Field" it's slow but with "Whole Field" it's
> instantaneous. I've confused now.
>

For reasons I don't quite understand, Access is asking for
the whole table and doing the filtering locally, unless you
specify FILTER or WHOLE FIELD.

Regards,


Ann