ADODB.recordset update values

[fredElliotRules]

Hi,

I've got a ADODB.recordset structure storing the results of the following query.

mysql = "SELECT (Int([age]/10)*10) AS [Age group], Count([Age Group]) AS Frequency " & _
"FROM Data " & _
"GROUP BY (Int([age]/10)*10);"

Now what I want to do is change the name of every record in [Age Group] to 10 - 20 instead of just 10. Is this possible using VBA?

Thank you