In VBA, how run SQL and get a SUM result ?

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I need to run an SQL which returns a SUM of a column. I
don't need a recordset. How do I do this. I looked
everywhere and tried everything I can think of and nothing
works so far.
I need to do this from VBA and I need the result in a
variable so I can show it on a form.
I need the quickest way to do this as it will be done very
often by mutliple users.
 
Back
Top