Using SQL to search through Access Indexes Sorry wrong section

bacon333

Senior member
Mar 12, 2003
524
0
0
Okay say I have two columns that are joined to create the index in a MS Access 2000 database. Those fields are PLS, and LINE. If I wanted to find a record with a particular PLS and LINE with SQL in the fastest way possible, can I use:

SELECT * FROM testtable WHERE (pls = blahblah and line = blahblah2)

or do i have to use some other keywords in the sql statement?

EDIT: opps wrong section