Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2017
    Posts
    2

    Unanswered: Access 2010 Calculated Field on Form Carries to next record

    I have 2 fields on a form; Strength1 and Strength2. I have a third field that is unbounded and has the source as =sum([strength1]+[strength2)/2 this shows the average. When i am in form mode and navigate to the next record, even though the strength fields are blank the average is still showing as the previous record. Also does not recalc the average for the next record when data is entered either.

  2. #2
    Join Date
    Mar 2017
    Posts
    2

    Cool

    solved my own question. instead of a calculated field in the form i created a calculated field in the table in datasheet view. that appears to have been the solution i wanted. thank you self

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •