Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Automation Updating a field in a table

Results 1 to 3 of 3
Share This Thread →
  1. #1
    jaccess is offline Registered User
    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
    alansidman's Avatar
    alansidman is offline Contributing User
    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    864
    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.

  3. #3
    jaccess is offline Registered User
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0
    Thanks for the reply. I have to find another way around

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates