Update field in table from a calculated query field
I have a form attached to a query with calculations. How do I make the calculated values write back to the table?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 17, 2009 8:30 PM
UPDATED:
April 24, 2009 10:40 PM
Answer Wiki:
Normally you can use the UPDATE statement or, better, have this done automatically by TRIGGERS.
Let's say you want to have a field that is DATE+USER and this "calculation" must be done automatically; simply create trigger to be executed AFTER INSERT that writes the given values.
To see all answers submitted to the Answer Wiki: View Answer History.
I think you will need to specify what programs and database you are using in order to get accurate responses.
I apologize for the confusion. I am using Access 2003. I have two fields that are concatenated to come up with an ID number. The query works great, but I need the result to write back to the underlying table. I know it is probably something very simple.
Thanks for all of your help.
In access, I think that when you modify the query results, the changes are applied to the table automatically, so if you assign the calculated number to a query’s field, that field will be updated in the underlying table.