more efficient calculations in queries or recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Ira said:
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.
Click to expand...

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.
 
Back
Top