Compound Indices

[JimS]

If I create a compound index on a table with, say, 2 columns in the index,
then join it to another table using both columns, will Access automatically
use the index, or is there some other way I should do that?

 

[Jerry Whittle]

To really know if Access uses an index, Google "access showplan". It tells
you how queries are actually run. Always us the results from the second time
a query is run after being created or modified.