Bit of a newbee question

I need to add 3 repeating fields from a orders table into one variable. I can display the records but not sure how to store them in a variable.

For example my variable is "items"

recordset fldName fldNum fldQty

variable "items" should = tshirt 123abc 5, shorts 123xyz 2

and so on

any ideas!

Hi

You could build a string from the record set. e.g

Field1|Field2|
A 1
B 2
The logic will look like this(Syntax not 100%)
Do Until rs.eof
  X = rs[Field1] & "," & rs[Field2] & "," & X
  Movenext
Loop
The result will be X = A,1,B,2

Hope this helps

Regards
Marnus