Results 1 to 2 of 2
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Access 2010 - Creating a calculated field from a different table

    The attached screenshot shows a subform that allows for multiple records of the indicated fields. The Exams field is a calculated field: =[Hard_drives]+[Phones]+[devices]. There may be several records in the same format, each with its own calculated Exams field. I want to add a field to another table and have that field (Total Exams) calculate the sum of each of the Exams fields in the subform. Can this be done? Thanks.
    Attached Images Attached Images
    JimmyW
    Helena, MT

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    To get the total you will need to sum the records each time you need the total.

    There are several ways to handle this on a form. One way I like to handle this is with a sub form. The subform is based on a query that calculates the total, in your case Sum([Hard_drives]+[Phones]+[devices]).
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

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