Any way to automate a Make Table Query?

[SteveGr]

Hi all,

I have a Access Database that has a table with a field named "Values". I would like to preform a calculation on all these records from within a query. (Adjusting them by a certain percentage) Then store them in another Table automatically.
I don't want to have to go thru the steps of a MakeTable Query. I want the calculation to perform by itself and update the Table. I know how to perform the calculation but how do I update the Table automatically?

Any help is much appreciated,
Stevegr

 

[sxu-mic]

Just curious: Why would you want to store the calculated results in a table and not another query?

 

[SteveGr]

Another software program is looking for the values in a table.

 

[sxu-mic]

Depending on how you want to trigger the action, you can use a macro.

 

[SteveGr]

I dont want to trigger the action though. I want it to do it without intervention.
Maybe a script of some sort?
Does anyone know how to write a script to alter record before going into a table coming from another source?