Add column in a table through query

[Nicawette]

Dear All,

I'm a newbies in access and I want to know how it is possible to add a
column in a table through a query?
This column will show the result of a query in the same table.

E.g. I have a table "A" and I want to add to table "A" in a cloumn the
result of my query made on the table "A" ?

is it possible ?

thank you

Nic

 

[John Vinson]

Dear All,

I'm a newbies in access and I want to know how it is possible to add a
column in a table through a query?
This column will show the result of a query in the same table.

E.g. I have a table "A" and I want to add to table "A" in a cloumn the
result of my query made on the table "A" ?

is it possible ?

thank you

Nic

I'm not sure what you intend. You can certainly put a "calculated"
field in a Query, by just typing a text string or an expression in a
vacant Field cell in the query design grid.

However, to make a permanent change to the structure of a Table you
would need to either use the table design window or execute a "DDL"
(Data Definition Language) query; see "Alter Table" in the online
help.

Normally tables should be pretty much static; if you need to
*routinely* add columns, there's something wrong with your database
design!

John W. Vinson[MVP]