Query Vs. VB

S

SAm

i am need to query a database to isolate days in a month and then do some
calculations with them. its a very intesive calculation which cannot be
described in here. basically, i want to know if i should do my calculations
as queries or as vba. my vba is improving, and my sql/query skills are
definetly better. which is the appropriate one to produce reports.

thanks,

sam
 
S

Sharkbyte

Sam:

The choice is really yours. I suppose I would suggest using queries, as it
gives you something easily tangible to base your reports on.

Sharkbyte
 
D

Douglas J Steele

It's almost always faster to use queries rather than VBA, although I suppose
it would really depend on the nature of your calculations.
 
Top