Hi,
I am creating a query that has several selection criteria entered from a form. I use switch and IIF statements to determine the data selection. This query takes a very long time to run. I am using a ODBC link to tables on a 2000 SQL server. I could use any suggestions on how to improve the run time of the query.