Openreport Parm : Wherecondition Parameter
UtterAccess Discussion Forums
May 19 2012, 04:09 PM
Does this parm provide equivalent performance of a recordsource that has the same where clause in the query SQL ?
May 19 2012, 04:20 PM
That's a good question, and my guess would be "yes" but one way to find out is to try it.
Just my 2 cents...
May 22 2012, 07:47 AM
Consensus is that it's likely only to be significant for large or complex queries.
This big question is: does the Access query optimizer get called for the Where Clause parm ?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please