Results 1 to 2 of 2
  1. #1
    adaoluz is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2017
    Posts
    46

    Calculation Error in SubForm


    Hello friends!


    I have already tried to calculate subform totals and it was impossible task.
    I turn to this Forum to help the most experienced in the subject
    I attached attached part of the project which is the best way to make me understand.
    Attached Files Attached Files

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    you're doing more work on this than you need to. You shouldn't need to alias your text fields and it appeared to be causing a problem with the sum. Not to mention the sum should be (I think) in the form footer not the page footer.

    Attached is a copy of your database that works.

    rp

    TotalErrado.zip

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-13-2016, 05:58 AM
  2. Replies: 8
    Last Post: 05-19-2014, 05:05 AM
  3. Subform Footer Calculation
    By bsc0617 in forum Forms
    Replies: 21
    Last Post: 08-29-2013, 02:28 PM
  4. subform calculation.
    By chivo123 in forum Access
    Replies: 11
    Last Post: 01-30-2012, 11:32 AM
  5. Subform vs main form calculation
    By fadone in forum Forms
    Replies: 17
    Last Post: 12-21-2005, 07:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums