Which filter is faster: Qry Access or Crystal Report

[petrovlis]

I have a "heavy" filter in Query Access
Like IFF ( IFF ( IFF etc etc
I wonder what is faster to make this filter in the
Access Qry or leave it out of the Access query and to have SAME
filter in Crystal Report 8.5 based on same qry as FORMULA .
(always same parameters)
Second: which is faster: if then ... or iif( AA ,BB
form
Thanks for help
William Rippen

 

[dhookom]

I have found queries in Access much faster but this was going against SQLAnywhere tables. You could test this and report back

Duane
MS Access MVP
Find out how to get great answers faq219-2884.