transferring data in rows of one table to columns of another table

[jkean]

Hi All,

We are working with FCC station data that puts some simple numeric data in
one file, arranged in a number of consecutive rows for each station. The next
station's data follows consecutively. Each group of rows that are common to a
station share an index number, while the next group uses its own separate
number.

A separate file contains the main information fields in a table of separate
rows, or records, along with a matching index number. We'd like to move the
numeric data in a group of rows that share the index # for a station, to a
series of new fields added to the record with the matching index # - a kind
of column-to-row move.

Is this something that can be automated within Access? Is so, what are the
steps (macro? VBA?)?

Thanks,
John

 

[Jeff Boyce]

Examples help ... could you provide a simple set of data showing the before
and after?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.