Set a variable equal to data from table

[medic133]

I have successfully opened a record set from a table (I think)containing five records. I want to use VBA to set a unique variable equal to each of the five records, and then perform calculations on these variables (such as add two of the variables together, then three, etc.). How do I go about setting these variables equal to the values returned in the record set?

 

[KenReay]

Hi

Say you recordset object is Rs, the you address each column with:

Rs!ColumnName

or

Rs("ColumnName&quot

You move through the record set from Row to row using a construct like

Do Until rs.EOF
Rs.MoveNext
Loop

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK