I have an ACCESS 2003 query where I am pulling data from a SQL table. the query runs very fast - a few seconds. I run another query off of the initial query to parse out the date from the DateTime field using DateValue function. The second query using the DateValue runs fast - a few seconds. Then I write another query to filter the date field. I want records after 12/31/2013 so in the date field the criteria is >#12/31/2013#. This query takes over 30 minutes to run. Is there a way to filter records more efficiently to return records after 12/31/2013? The file has records from 2000.