Howdy.

I'm using an access database to record some stuff.
There's about 10000 records in the database. Each record has about 30 fields.

I'm using my own numbering system (because I dont trust Access). The RecNum field is a unique numeric field that says what record number this record is.

So for viewing things etc. I use Select * From CompanyInfoTable Where RecNum = n.....

And its going great.

But now I have to write a piece of code to make reports.
Its going to be outputting fields from various fields.
And its going to have to go through each record.

I was thinking of just storing what the total number of records is as a long, then using a do loop :
Do Until i = totalRecordNumber
' ...
Loop

And then looping thru each record and saving it to the file.

Is there any better way of doing this ?
I just want to pick out say 4 or 5 fields from each of the 10,000 records and put that into a file.