Speed up a report?

[Scott Loupin]

I've a report that is fed off several dlookup queries and takes several
minutes to generate. When I hit Print, it again takes several minutes to
print. Any way to speed up the process?

Thanks.

 

[Duane Hookom]

Replace your DLookup()s with other types of expressions.

 

[Rick Brandt]

I've a report that is fed off several dlookup queries and takes
several minutes to generate. When I hit Print, it again takes
several minutes to print. Any way to speed up the process?

Thanks.

As a general rule the domain functions (like DLookup()) should be avoided in
sitiuations where they will be called repeatedly such as in a query or
report. Where are you using the DLookups()? If a few are used in
Header/Footer sections it might not be too bad, but if they are being called
"per row" there is a good chance that this is your problem.

One can usually accomplish what is needed without using DLookup(). If you
post the structure of your report you might get some alternative ideas.