Transferring Data from Fields in Repeated Rows to a Single Row

[Steck]

I have used Access to extract data from an exterior relational database and put it in a table by using a make-table query.

The table consists of duplicate rows of records for individuals who are recipients of varying numbers of funds. One person's data may reside in a single row or in multiple rows, depending on the number of funds she has received. The column values that vary in the duplicate rows are a currency value (the fund dollars received) and an integer value (fund ledger account number).

From this raw data I want to produce a report text file that will consist of a single row for each person receiving funds, with all fund amounts/ledger numbers in the columns comprising her row. So, for example, in one person's row, the columns "Fund1" through "Fund 6" would be populated, and in another person's row only "Fund1" would be populated.

Can I use Access functionality to automate this process, or must I create additional columns for the table to hold the data, and then drag and drop the data to the new columns manually? [sig][/sig]

 

[jagilman]

If you loop thru the query or recordset you could build the text string until the recipients ID changes, and then start a new line in the text file.

Are you familular with recordset objects?

[sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]