Have not started to play with doing this, but looking it over, it still seems like the work is being done from access, which is what is causing the slowdown. I was wondering if I had the full query (all offices) done on the SQL server, then used a query on access to filter for just the office number, would that be quicker? That way I would not have to pass anything.