Data summary on an unbound form

  • Thread starter Thread starter johnb
  • Start date Start date
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
 
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
 
Back
Top