Denormalise an Access Database, to 'flatten' it out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I've got a large Access database, and want to transfer some of it to ACT
- but need to flatten some of the data as they are in one to many
relationships.
For example, one person in this recruiter database has many employers in a
related table (so one personid, many personcompanyid). Want to concatenate,
so in the field it just has 'current employer name; previous employer name;
2nd previous employer name' etc. With each name just separated by a
semi-colon.

Anyone go any ideas? Really struggling with this.
Toby from Sydney
 
Back
Top