Is it possible to index a database with a date field? I have a database that has 2 million records and would like to search records by the transaction date. Using the ADO seek will work but takes a long time. Not sure how to do about this, if it possible at all. I am using VB 6.0 with ADO. The database is an Advantage Database. I can also use SQL too, I guess. Any thoughts or comments would be appreciated.