using results of SQL SUM... as fieldName

[dogdays]

win 732 access 2003
I have executed an SQL statement:

SELECT nHouseholdNumber, nIndividualNumber, SUM (cAmount) as 'cTotalAmount'  FROM tblFiscalGifts WHERE nIdentity > 0  AND (dtDateEntered >= #7/3/2011# AND dtDateEntered <= #10/03/2011#) GROUP BY nHouseholdNumber, nIndividualNumber

I tried using the following to get the SUM variable cTotalAmount using

    cTotAmount = fiscalGiftsRecSet.Fields("cTotalAmount")

I get an error message stating this item is not in the collection How do I retrieve the results of the SQL statement?

tia Jack

 

[dogdays]

I dropped the single quotes around cTotalAmount and all is fine.

Jack

 

[Norie]

Have you moved to a record in the recordset or are you moving through it's records?