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

On 10 Nov 2006 04:59:37 -0800, "Nicawette" <(E-Mail Removed)>
wrote:

>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]