how do you store query results to an existing table

[tweety]

Has anyone got any links on how to store query results to an existing table, I have checked on Google but didn't find anythink, this is this site i found http://office.microsoft.com/en-gb/ac...76527.aspx#BM4

after trying this, access gives this error message




Thanks

[Amerlitong]

i guess your doing UPDATE QUERY from other QUERY?...

[Amerlitong]

try using NESTED queries...

i will give you an idea...

UPDATE table
SET field = field * 2
WHERE field IN
(SELECT field FROM table
WHERE field IN
(SELECT field FROM table
WHERE field = any))

i hope this works...

Cheers

[tweety]

iam trying to use the results from the query in the screen shot, and write\save them to a table i already have (products)