[AccessD] Output text file--HELP

Mark,

As you are looping though, can you force the zip code to be a string by
using CStr(rst!ZipCode)?

Dan Waters
ProMation Systems, Inc.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, March 25, 2005 3:22 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Output text file--HELP

Hello All,

Of course its Friday...I have a table with one field...its a zip code...I 
need all records in the field to be in a string.  I know its not that 
hard...but the brain isn;t working right.  I want to output the following:

Record   Zip
  1         55555
  2         54879
  3         12345

I need a string( preferable in a text document) like "55555,54879,12345"

I thought this would be a simple loop through the recordset and output to a 
.txt file...but I cant seem to figure it out.  Best approaches?

Thanks,

Mark A. Matte


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com