Hi ,
I have a Recordset something like this

Set rstDescription = db.OpenRecordset("SELECT [StrPrimaryAttribute]&" = "& [StrValue] FROM tblTempWindsorOrder WHERE IntId =" & Itemnumber)
My Q is how to store the values that this select statment will return ,in a Variable since this will return more than 1 value .
I am using a DAO Access Databse...any suggestions will be helpful.

Thanx
himangi