... solved ??
otherwise:
define a query:
Code:
Set qry = CurrentDb.CreateQueryDef("", [SQL])
... [SQL] is your SQL statement, just as posted by Orange
run the query
Code:
Set tbl = qry.OpenRecordset(dbOpenDynaset)
loop through tbl to add your nnumbers ...
Code:
Do Until tbl.EOF
... sum ... however
tbl.MoveNext
Loop
You might do it three times to get three numbers, as "sum from date - 12month up to date", "sum from date - 24 to date" , ... i think it is what you intended.
I think it is not possible, to make a SQL statement return three integers directly.