Hello:
I have read in Access Help that using IIF statements in queries does not allow the query to be optimized and can be a cause for slow performance.
Simple question: If I create a public function to do my IIF statment operation will this allow the query to be optimized and run at maximum speed?
Just curious,
Dwight
I have read in Access Help that using IIF statements in queries does not allow the query to be optimized and can be a cause for slow performance.
Simple question: If I create a public function to do my IIF statment operation will this allow the query to be optimized and run at maximum speed?
Just curious,
Dwight