Looping through records

[Chuck]

Not sure if this is the correct newsgroup...

I have imported an Excel spreadsheet that has the appearance of a report
(headings, totals, etc). It imports easily and each column becomes a field
in a table very nicely. I can build a table stripping out unnecessary
information. One issue I cannot figure out is as follows.

The first column and the first record of the spreadsheet contains the
department name in which employees belong. The second column through the
tenth column contain employee information, however, each line after the
first does not contain the department name until it changes to a new
department listing the employees in that department. This continues
throughout the report.

The imported information has all the records but not the department name on
each employee. How do I loop through the records, reading the one record
containing the department name and populating it into the field for each
employee in that department? Then find the next department name, and
populate its name into the following employees, and so on.

Any help would be appreciated. Thanks

 

[Guest]

I'd say you have to do this in Excel before you import to Access. Access has
no way of knowing which group belongs together unless you identify the
department before importing.

Sheila
www.c-i-m-s.com