Data summary on an unbound form

J

johnb

Hi,

I need to summarise data from several diferent tables on
to a single unbound form. The db in question is slow now
so I'm looking to avoid slowing it any more. My first
choice was to use a series if DSUM's but then I thought
will queries and subform be more efficient? Or is there a
another way. comment most welcome.

TIA johnb
 
M

MacDermott

If your db is slow now, you may well be missing some indexes on fields which
are sorted, filtered, or linked.
Unless your db is close to the 2 GB size maximum, chances are that will take
care of the problem.
My experience has been that a single DSUM is more efficient than opening a
recordset, but neither is slow enough to be noticeable to a user.
Subforms can take a noticeable time to load, but once in place are pretty
efficient, too.

HTH
- Turtle
 
Top