#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0

    Automation Updating a field in a table


    Hi
    I have a form which enters data into a table. Field total amount (FieldF) is an equation of ((FieldE*FieldD) * (FieldA+FieldB+FieldC)). When I enter the equation into the text box the correct amount is shown, but it is not linked to the field in the Table where FieldF, the control source has been replaced by the equation. I have tried to use a query using FieldF: ((FieldE*FieldD) * (FieldA+FieldB+FieldC)) selecting FieldA's Table in the table column. This didn't work either and returned a automation error? any suggestions.

    thanks

    jeremy
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    865
    Rep Power
    152
    It is not a good practice to put calculated fields into tables. If data changes then you have to update all the calculations or you could end up with misleading or bad information. Calculations should remain in forms for viewing, in queries and reports for analysis and reporting. All calculations can be done on the fly in queries and forms as needed.

    Alan
    Alan Sidman
    Office 2010, 2007, 2002

    If I helped you, then click "give rep" button in the lower left corner.
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0
    Thanks for the reply. I have to find another way around

Similar Threads

  1. Updating a composite key field in a table.
    By maverick_me84 in forum Microsoft Access Help
    Replies: 2
    Last Post: October 9th, 2006, 11:16 AM
  2. Combo Box not updating table field properly
    By Rickilynn in forum Microsoft Access Help
    Replies: 3
    Last Post: August 18th, 2005, 04:02 AM
  3. Replies: 21
    Last Post: June 28th, 2005, 02:35 PM
  4. Updating Table Field Values From A Form
    By lhasha in forum Microsoft Access Help
    Replies: 1
    Last Post: December 6th, 2004, 05:29 AM
  5. Updating corresponding field in table
    By musicfanz in forum Microsoft Access Help
    Replies: 3
    Last Post: February 11th, 2004, 04:45 AM

IMN logo majestic logo threadwatch logo seochat tools logo