When to use which? SQL vs VBA

[techcrium]

Hi, anyone know when you should use which to solve your problem?

For example, lets say you have to find the average of a list of columns in the table.

You can either
A) Use SQL: SELECT AVG(column_name) FROM table_name


B) Use VBA: Pass the table object or call the table object, iterate through each and add them and then divide by number of numbers.


Which is better to do? when should you do one or the other?

 

[jdraw]

Why don't you try it each way, record your findings and tell us what you learned?