This is the VBA forum. If you're using Access, a couple million records in one table is way more than it was designed to handle. If you're using SQL server, MySQL, Oracle, etc, you might get better results in the database forum.