Copy sum from database recordset

[phenley3]

Hello forum,

I have some code below that I've found that pastes an entire recordset (which is a query) from a database and pastes it in cell A2. Is there a way for me to be able to paste just the sum of a single field from the record set in cell A2?

Sheets("Existing Access Query").Range("A2").CopyFromRecordset rs

Thank you so much for your help.