DAO Recordset as DSum domain?

[GraeagleBill]

Is Access telling me I cannot use a DAO Recordset as the domain expression in a DSum function?


(rsBefore is DAO Recordset It is currently open)

[CJ_London]

That is correct. Dsum references a table or query object. A recordset is not an object. Why not just use a query to generate what you require?

[GraeagleBill]

That's what I'll do. How do I get the value of a field in the last record of a sorted query? (That's why I'd loaded the select into a DAO recordset to gain access to MoveLast, MoveNext, etc. type commands)

[CJ_London]

sort it in descending order and use SELECT TOP 1

using movefirst/last etc in a vba sub or function is the slowest possible way of doing things

Perhaps if you explained in simple English what you are trying to do I can suggest the appropriate sql

[GraeagleBill]

No problem, Ill save the query def and let jet do the summations and use your suggestion to get the field out of the last record. Thanks for the offer.
Bill