Query Vs. VB

[Guest]

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

 

[Guest]

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

 

[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.