Open the table in design view
Select the field name you want to be indexed
On the field properties at the bottom on the General tab change
Indexed to Yes (Duplicates OK)
To speed up your queries, try indexing (in your table structure) on the
fields you use (in your query) for:
* joining tables
* selecting values (selection criterion)
* sorting
You may need to do some experimenting. Consider reading up on Indexing --
not every field used as above is a good candidate for indexing.
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.
