Martijn is right, but he forgot to mention that this new index would have
to be descending. An ascending index (default) is useful for checking less
than something, whereas you want something greater than a set value and
need a descending index.

HTH,
Set

At 14:19 12.05.2003 +0200, you wrote:

> > 2.
> > Make a new field in the table which is just a calculated fields
> > ((MyField1*100)+MyField2) and then make an index on this new field ?
>
>Yes.