Sum, Min, Max

[ironmunk]

How do you store the value from the following SQL commands to a variable

MIN, MAX, SUM, AVG

 

[tlbroadbent]

Could you give an example of what you are doing? Do you have a query? Are you opening a record set? Are you working in VB code? Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.

 

[ironmunk]

sorry, here you go

ssql = "select sum (inputbytes) as test from DB"
Set rstArchive = LANarchiveDB.OpenRecordset(ssql)
Do Until rstArchive.EOF = True
temp = <what goes here>
rstArchive.MoveNext
Loop
rstArchive.Close

 

[tlbroadbent]

temp = rstArchive!test Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.