displaying sum on form (dsum) taking long to load

[gangel]

Hey everyone,

So im 80% done on my big access project for my business and im trying to make some things better from when i first made them!

Currently i have my total outstanding invoices ($) displayed on one of my main forms when i open it.

Originally:
I used a subform based on a query which was had SumOfInvoiceValue
This took about 5 seconds to load and would sometimes produce an error (which i finally fixed but found Option 2 at same time)

Option 2:
Got rid of the subform based on a query and just used Dsum to get the sum of invoice value.

This takes about... 1.5-2 seconds to load the values.


What do i do to make this faster?? Or what am i doing wrong...


It is a basic principle, but obviously im going about it the wrong way! :S

Any help would be great~!

[ranman256]

You dont need DSUM (slow)

in the subform footer, just use SUM
set the textbox = SUM([field])