Mapping multiple fields to one field

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

Guest

I have an output table generated by a web based form that looks like this
(example):

Facility Project 1 info. Project 2 info etc....
LabA abc def

I want to map this into a table that looks like this

Facility Project info
LabA abc
LabA def

So basically I want to convert one long array of data into less columns with
multiple rows. Can someone push me in the right direction on how to go about
this?

Thanks in advance.
~Theresa
 
Theresa

I believe what you're looking for is termed a "normalizing query".
Actually, you'd need several queries, one for each column you are
converting.

Create your new table structure. Create your (first) query to append the
first Project# column and Facility to your new table. Make a copy of that
query and change it to get the second Project# column ... and append.
Repeat until all Project# columns have been appended.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Thanks Jeff. I'll try that out.

Jeff Boyce said:
Theresa

I believe what you're looking for is termed a "normalizing query".
Actually, you'd need several queries, one for each column you are
converting.

Create your new table structure. Create your (first) query to append the
first Project# column and Facility to your new table. Make a copy of that
query and change it to get the second Project# column ... and append.
Repeat until all Project# columns have been appended.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
Click to expand...
 
Back
Top