Dynamically Renaming Fields?

[Kosio]

Is there any way to setup a make-table query so that it names the
fields of the new table based on values in a different table.

For example, I have the following fields: Noun, Adjective, Modi 1 Name,
Mod 2 Name, Mod 1 Val, and Mod 2 Val. Listed under these fields are
the records of the table and the value of each field.
Noun | Adjective | Mod 1 Name | Mod 2 Name|Mod 1 Val|Mod 2 Val|
-------|------------|------------|-----------|---------|---------|
<name> |<adjective> | Value | Power | 255 | 65W |
<name2>|<adjective2>| Tolerance | Package | 5% | 0603 |
-------|------------|------------|-----------|---------|---------|

Is there a way to use a make-table query to make a new table that
automatically names the fields based on a value in a table?

The new tables made from a make-table query:

New Table 1:

Noun | Adjective | Value | Power |
-------|--------------|--------|-------|
<name> | <adjective> | 255 | 65W |
----------------------------------------

New Table 2:

Noun | Adjective | Tolerance | Package |
-------|--------------|-----------|---------|
<name> | <adjective> | 5% | 0603 |
---------------------------------------------

[Larry Linson]

Certainly, simply create "calculated fields" in the Select Query that you
convert to MakeTable. For example, if I have a table with fields of RowID,
Room, Chair1, and Chair2, and want a new table with Row, Place, Person1, and
Person2, then in the Query grid, I'd have the following:

Row | Place: Room | Person1:Chair1 | Person2:Chair2

and if you look at SQL View, you'll see

SELECT tblMadeANew1.RowID AS Row, tblMadeANew1.Room AS Place,
tblMadeANew1.Chair1 AS Person1, tblMadeANew1.Chair2 AS Person2 INTO
tblMakeANew3
FROM tblMadeANew1;

Larry Linson
Microsoft Access MVP
"Kosio" <aa********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Is there any way to setup a make-table query so that it names the
fields of the new table based on values in a different table.

For example, I have the following fields: Noun, Adjective, Modi 1 Name,
Mod 2 Name, Mod 1 Val, and Mod 2 Val. Listed under these fields are
the records of the table and the value of each field.
Noun | Adjective | Mod 1 Name | Mod 2 Name|Mod 1 Val|Mod 2 Val|
-------|------------|------------|-----------|---------|---------|
<name> |<adjective> | Value | Power | 255 | 65W |
<name2>|<adjective2>| Tolerance | Package | 5% | 0603 |
-------|------------|------------|-----------|---------|---------|

Is there a way to use a make-table query to make a new table that
automatically names the fields based on a value in a table?

The new tables made from a make-table query:

New Table 1:

Noun | Adjective | Value | Power |
-------|--------------|--------|-------|
<name> | <adjective> | 255 | 65W |
----------------------------------------

New Table 2:

Noun | Adjective | Tolerance | Package |
-------|--------------|-----------|---------|
<name> | <adjective> | 5% | 0603 |
---------------------------------------------