I need to move or copy data from one table into a single row in another table.

[dave]

I may be asking a question that's simply impossible, as I have searched far and wide but have not been able to find


a solution (or it as been under my nose all along, and I've just missed it.)

Say I have the following table:

Job Number	Customer Name	Distributor Name
55	John Doe 1	Distributor Center 1
55	John Doe 2	Distributor Center 2
55	John Doe 3	Distributor Center 3

I am trying to manipulate this data (maybe through an append query into an already established table) like so:

Job Number	Customer 1	Customer 2	Customer 3	Dist 1	Dist2	Dist3
55	John Doe 1	John Doe 2	John Doe 3	Distributor 1	Distributor 2	Distributor 3

[Minty]

This is moving data from a sensible normalised structure, into a non-normalised horrible (excel like) structure.

You could produce a report or query to display this data in that format, but I certainly wouldn't store it like that. It serves no sensible purpose.
If you suddenly have Customer 4 or distributor 4 you would have to redesign the whole process, or leap through a lot of hoops to get around the problem.

One always has to ask why.
And is never surprised to hear, "That's the way the boss had his old report in his spreadsheet..."

So make him a nice new shiny report with better presentation of the facts, and tell him that's "A silly way to store data"