Use an index name in a query?

[pvg]

I have created an index name in a table which has multiple fields in it that provides a unique key.  How do you use an index name in a query.

 

[Guest_imported]

Please show a better example of what you mean. If you created an index you would have had to do that to an already named field. Just refer to the name of that field in your query<br>IE.. recordid is my index or key field<br><br>SELECT table1.ID<br>FROM table1<br>WHERE (((table1.ID)=1));<br><br><br><br>