Reading a recordset to a single variable

GJParker · Sep 17, 2002

Hi,

I would like to cocatenate the contents of a recordset to a single string variable, with a comma between each record.

strCoCat = "rs[1]","rs[2]","rs[3]"....

Thanks.
Gary Parker
Systems Support Analyst

HowardMarks · Sep 17, 2002

strCoCat = rs[1] & rs[2] & rs[3] & rs[4]

etc. etc. etc.

Nick (Web Developer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

HowardMarks · Sep 17, 2002

Oop sorry if you want commas in between it would be

strConCat = rs[1] & "," & rs[2] & "," & rs[3] & "," & rs[4]

etc etc... Nick (Web Developer)

http://www.retrographics.co.uk

nick@retrographics.co.uk

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Reading a recordset to a single variable

GJParker

Programmer

HowardMarks

MIS

HowardMarks

MIS

Similar threads

Part and Inventory Search

Sponsor