<div>
that is what is was looking to do - i ended up doing a cut and past with excel and then linking within Access a primary_id. This will work if every i need to do again.<br />
<br />
Thank &nbsp;you
</div>


that is what is was looking to do - i ended up doing a cut and past with excel and then linking within Access a primary_id. This will work if every i need to do again.

Thank  you

<div>
<div class="content wysiwyg-content">
Access 2003 table<br />
<br />
Field1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Field 2<br />
Sally &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Red<br />
Sally &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;green<br />
Sally &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Purple<br />
Fred &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange<br />
Fred &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;red<br />
<br />
<br />
I want to change to<br />
<br />
Field1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;field3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; field4<br />
Sally &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;red &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;green &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;purple<br />
Fred &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;orange &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;red &nbsp; &nbsp; &nbsp;
</div>
</div>


Access 2003 table

Field1             Field 2
Sally            Red
Sally            green
Sally            Purple
Fred            orange
Fred            red


I want to change to

Field1            field2            field3             field4
Sally            red            green            purple
Fred            orange            red      

Access 2003 flip data in columns to rows

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.