DLookup/Dsum Alternatives (1 Viewer)

[D-Fresh]

I have a basic summary report that pulls in data from a lot of tables. In order to populate this report, I am using the DLookup and DSum functions. Needless to say, this takes quite a bit of time for the report to open up, and I'm sure just hogs up system resources. Is there any alternatives to using these functions? I pull data in from at least 15-20 different queries/tables on my report. Any help would be greatly appreciated. Thanks.

Doug

 

[Pat Hartman]

It really depends on the relationships between the various queries. DLookup()s can usually be replaced by adding a join to the lookup table into a query. That way you can pick up the description field in the main query. Joins are MUCH more efficient than DLookup(). You might try adding subreports based on "totals" queries to show the summary data rather than doing DSum()s.