query soft indexing (1 Viewer)

[syodb]

Is it possible to index a field in query?. Like give it a uniqueness like we do it in an actual table setup?. access 2003 and above.

 

[June7]

Indexing is set in table design, not queries.

Can, however, SELECT DISTINCT in a query.