Index Field In Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can a field in a query be indexed? CreateField and CreateIndex in the Help
file seem to imply that this can be done.

Thanks!
 
No.

With Access (JET) tables, you can only create an index on a field in a
table.

(Of course, if you do that, the query will benefit from the index.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign Index key to field programmatically 4
Nulls and Strings comming from SQL 2
setting index on temporary table 4
DAO and Indexing 2
Index with descending field 7
Help with Access VBA to create a new file and import textfile data 7
Compund index Using ADO 12
building a linked table in VBA 2

Back
Top