merging 2 columns into 1 1

[JaredTaylor74]

i have a table that has 2 columns that i need to make one.

Here is some data in the orig table

SetName Base Tooling ToolingType
15-02BD 15-02 1-2 SHUTTLE
15-02BD 15-02 15-02 2A/B SLIDE
15-02BD 15-02 15-02 1A/B SLIDE
15-02T 15-02 27-28 SHUTTLE
15-02T 15-02 29-30 SHUTTLE
15-02T 15-02 15-02 1A/B SLIDE
15-02T 15-02 15-02 2A/B SLIDE

for each set name i need to move the Base column to the Tooling column with the ToolingType as Base
like this...

SetName Tooling ToolingType
15-02BD 15-02 BASE
15-02BD 1-2 SHUTTLE
15-02BD 15-02 2A/B SLIDE
15-02BD 15-02 1A/B SLIDE
15-02T 15-02 BASE
15-02T 27-28 SHUTTLE
15-02T 29-30 SHUTTLE
15-02T 15-02 1A/B SLIDE
15-02T 15-02 2A/B SLIDE

is there an easy way to do this?

Thanks for your help and happy holidays.

Jared

 

[DoubleD]

The quickest, but dirty, way to do this is as follows:
Write a make table query, to create a temp table, Group on SetName, Base, and add a Tooling Type field with text "Base" as the entry.

Delete the Base column from your original table.
Append all the records from your temp table into your original table.
Delete the temp table.

I am what I am based on the decisions I have made.

DoubleD

 

[JaredTaylor74]

cool. works for me.

Thanks.

Jared