Select / Append Query

[alecgreen]

Hi

I have a Orders table thats show Sales Order No, Sales Order Line and
Sales Order Details, if I run a basic select query, I get three
columns and multiple rows depending on the number of records.

Sales Order No, Sales Order Line, Sales Order Detail
123 01 Valve
123 02 Seal
123 03 Bolt

I now want to use an append query to fill a new table, which has Sales
Order No, Ln1, Ln2, Ln3 etc so in turn I have an append query to fill
Ln1 then Ln2 then Ln3 etc so the end result all Order records in one
row, rather than multiple rows

Sales Order No, Ln1 ,Ln2 ,Ln3
123 Valve, Seal, Bolt

Any ideas please

Alec

 

[Bob Barrows]

Hi

I have a Orders table thats show Sales Order No, Sales Order Line and
Sales Order Details, if I run a basic select query, I get three
columns and multiple rows depending on the number of records.

Sales Order No, Sales Order Line, Sales Order Detail
123 01 Valve
123 02 Seal
123 03 Bolt

I now want to use an append query to fill a new table, which has Sales
Order No, Ln1, Ln2, Ln3 etc so in turn I have an append query to fill
Ln1 then Ln2 then Ln3 etc so the end result all Order records in one
row, rather than multiple rows

Sales Order No, Ln1 ,Ln2 ,Ln3
123 Valve, Seal, Bolt

Any ideas please

Crosstab query wizard.
But don't create a new table. Just create the crosstab query and base your
report/whatever on it