I feel like I've seen this addressed here before, but couldn't find it. I'm curious what the experts here think. (This may be a VBA question rather than a query question, but since it deals with queries I thought I'd put it here first.)
Before I spend a lot of time designing a suboptimal solution, I'm hoping to focus my effort on the best method. So I'm wondering what processes faster: Requerying a table based on a narrow set of criteria multiple times for mutliple sets of narrow criteria and processing the data before querying again, or querying once on a more general set of criteria and iterating through the resulting recordset and processing that way.
Many thanks!
Before I spend a lot of time designing a suboptimal solution, I'm hoping to focus my effort on the best method. So I'm wondering what processes faster: Requerying a table based on a narrow set of criteria multiple times for mutliple sets of narrow criteria and processing the data before querying again, or querying once on a more general set of criteria and iterating through the resulting recordset and processing that way.
Many thanks!