Update field in table from a calculated query field

15 pts.
Tags:
Calculating fields
Query
I have a form attached to a query with calculations. How do I make the calculated values write back to the table?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I think you will need to specify what programs and database you are using in order to get accurate responses.
    69,475 pointsBadges:
    report
  • MahiraAgate
    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.
    15 pointsBadges:
    report
  • carlosdl
    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.
    69,475 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following