Extracting Data

[Rjc8513]

The following represents my table structure:

Acct No. Deposit W/D Balance
0036242 50.00 10.00 6524.00
0036242 100.00 50.00 6574.00
0038291 500.00 50.00 10729.00
0038291 1200.00 300.00 11629.00
0038291 750.00 0.00 12379.00

The table contains over 4000 records. Each
Acct. No. has any number of entries. How can I
cycle thru the table, extracting all the
transactions for each Acct. No.? Then, how can
I output the transactions for each Acct. No. to
a separate file using the Acct. No. as the name
(0036242.txt)? Thanks.

Richard...

 

[dawnd3]

I can't help you all the way there, but I can give you some ideas. There is a transfer text action that will allow you to transfer to a text file format. You can also within the code name the file using the contents of the Account number field. What I DON'T know how to do is have it loop around to handle every account. So my novice attempt at this would be to run a query that pulls the account number off of a combo box on a form, and I would go and do each account one at a time, and have a button on the form that runs the transfer text stuff. I know there is a quicker way, but this might get you started. Dawn