Create as one record

D

David Kennedy

Thanks in advance for any help.

I have a table with the following fields and sample data:

Make MakeNumber Manufacturer ManufNumber ManufSpecific
ManufSpecificValue
CAR A123 XXXX AA1
Dimension 1 100mm
CAR A123 XXXX AA1
Dimension 2 50mm
CAR A123 XXXX AA1
Height 50mm
CAR A123 XXXX AA2
Colour Red
BUS ZZ00 YYY WSA9
Dimension 1 60mm
BUS ZZ00 YYY WSA9
Dimension 2 30mm
BUS ZZ00 YYY WSA9
Dimension 3 12mm
BUS ZZ00 YYY WSA9
Height 120mm

Is there a way (using code) to put the dimensions and corresponding
information in one record? ie:

Make MakeNumber Manufacturer ManufNumber ManufSpecificA
ManufSpecificValueA ManufSpecificB ManufSpecificValueB..and so on
CAR A123 XXXX AA1
Dimension 1 100mm Dimension 2 50mm
Height 50mm
CAR A123 XXXX AA2
Colour Red
BUS ZZ00 YYY WSA9
Dimension 1 60mm Dimension 2 30mm
...and so on

I have been able to do this using various different queries but was
wondering if a single piece of code would do the trick?

any help would be greatly appreciated
Thanks again
David K
 
D

David Kennedy

Apologies,that last mail looks terrible,

The table has the following fields and sample data:

Mk MkNum Man ManNum ManSpec Val
CAR A123 XXXX AA1 Dim 1 100mm
CAR A123 XXXX AA1 Dim 2 50mm
CAR A123 XXXX AA1 Height 50mm
CAR A123 XXXX AA2 Colour Red
BUS ZZ00 YYY WSA9 Dim 1 60mm
BUS ZZ00 YYY WSA9 Dim 2 30mm
BUS ZZ00 YYY WSA9 Dim 3 12mm
BUS ZZ00 YYY WSA9 Height 120mm


Is there a way (using code) to put the dimensions and corresponding
data into one record? ie:

Mk MkNum Man ManNum ManSpecA ValA ManSpecB...
CAR A123 XXXX AA1 Dim1 100mm Dim2 ....
CAR A123 XXXX AA2 Colour Red
BUS ZZ00 YYY WSA9 Dim1 60mm Dim2 ....

I have been able to do this using various different queries but was
wondering if a single piece of code would do the trick?

any help would be greatly appreciated
Thanks again
David K
 
Top