MS Access index and SQL

[stordaz]

Hi,

How can I write a select statement using an index
on an Microsoft Access database?

I mean...
I have a table Tab1 with a few indexes (Index1 made up with Field1, Field2,... - Index2 made up with Field1, Field3 - and so on).
How can I write a select on table Tab1 using one of these index?
Is it necessary or SQL arranges the query by itself?

Thanks in advance

 

[JABE]

If your intention is to sort your resultset, use the ORDER BY clause of your SQL statement. Indexes have no bearing on how a resultset is sorted to the client app.

 

[quwiltw]

Access will make use of indices as it can. You dont explicitly reference them in queries.