more efficient calculations in queries or recordsets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ira - 24 Mar 2005 20:25 GMT

What is more efficient to use for performing more complex calculations SQL
(queries) or VBA (recordsets)? We are automating a spreadsheet process for a
client in Access. Our consultant has built a series of calculations using
queries that basically build onto each other. Our initial reaction is that
this is probably not the best nor most efficient way to do it.

Reply to this Message

Dirk Goldgar - 24 Mar 2005 20:36 GMT

> What is more efficient to use for performing more complex
> calculations SQL (queries) or VBA (recordsets)? We are automating a
> spreadsheet process for a client in Access. Our consultant has built
> a series of calculations using queries that basically build onto each
> other. Our initial reaction is that this is probably not the best
> nor most efficient way to do it.

Operations on multiple records that can be done via queries are usually
more efficient than recordset operations, but it depends on exactly what
you're doing.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message