General question regarding RecordSets

[ChewDinCompSci]

When using recordsets is it possible to refer to a previous recordset (a previous record in your data table) and make a calculation on two numbers, each number being from a seperate record in the table?

MatChew
codename: vba4dumbE

 

[Golom]

The short answer is "yes" but you need to provide more detail about how to identify the "previous" record.

Also ... the term "recordset" has some special connotations. Do you mean DAO (or ADO) recordsets or are you just using the term to mean "... a set of rows from the database ...?

 

[ChewDinCompSci]

Golom,
From what I've heard, DAO is oldschool and out of date. I've used ADO so I suppose I would use ADO here. Or is there a way to simply refer to a previous row in a table without using recordsets? I appreciate your help.

MatChew
codename: vba4dumbE