confuse
08-06-2008, 10:56 PM
Hi....
I would like to ask if is it possible to pass value from query to table. Because I have a query which i calculated the value of one field. And i would like to store this one to a table.
Can i do this??and if, can i have some sample codes or idea...
Thanks....
namliam
08-06-2008, 11:11 PM
NO you cannot and you should not!
Calculated values (with very very few exceptions) should NEVER be stored in tables!
If you really need/like to do this, look into update or Insert queries..
confuse
08-06-2008, 11:25 PM
NO you cannot and you should not!
Calculated values (with very very few exceptions) should NEVER be stored in tables!
If you really need/like to do this, look into update or Insert queries..
Im sorry but where can i do the update and insert query and how???
namliam
08-06-2008, 11:50 PM
NO you cannot and you should not!
Calculated values (with very very few exceptions) should NEVER be stored in tables!
First let me repeat myself... DONT save calculated values... You really really really shouldnt do that...
Now to change the 'type' of your query when in query design, in the menu: Query => Update/Append