If you calcs are not very complex and your competition is ten times faster, I think you should reanalyse your db model. Also analyse the dynamics of data changes. Maybe you can work with offline tables? Tip: a physical sorted table is scanned dozens of times faster than an ordered table (especially on network app).

Vlad

>Thank you for your input Paul.
>My largest table is 30 fields with 50,000 records.
>The calcs are not terribly complex; most often they take 3 to 4 values from several tables and perform a common operation on them. One complication is the necessity to do some Immediate IF (IIF) tests within calculations to determine which multiplier to use in given calculation.