Looping through columns 1 and 2 only of a recordset

[mp3909]

Is it possible to loop all the way down through a specific column of a recordset?

For example, my recordset contains 3 columns but I only want columns 1 and 2.

[JoeM]

How exactly are you looping through it, and what exacly are you trying to do?
When looping through records, you can reference any columns that you like.

[CJ_London]

not sure what your issue is - recordsets have fields, not columns - and field have names, so just refer to the field name - or use the field index

myrecordset!fieldnameX
myrecordset.fields(0)

[mp3909]

thanks Ajax, working now.