more efficient calculations in queries or recordsets

[Guest]

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.

 

[Dirk Goldgar]

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.