Is this efficient?

AUGuy

Newly Registered Idiot
Local time
Today, 12:52
Joined
Jul 20, 2010
Messages
135
I've got a summary form that counts/sums up amounts in several tables to display on a single, printable form. The method I've used for pulling/displaying this information is via 90 text boxes, each one using DSum and DCount. Here's an example of one of the text box values:
Code:
=IIf(IsNull(Round(DSum("[Current Balance]","[Combined Data File]","[Loss Share Code] Like 'N*' AND [Status]='Active' AND [System]='CL'"),2)),0,Round(DSum("[Current Balance]","[Combined Data File]","[Loss Share Code] Like 'N*' AND [Status]='Active' AND [System]='CL'"),2))

My question is this: Is this the most efficient way to carry out these 90 calculations?

Thanks, G
 

Users who are viewing this thread

Back
Top Bottom