Results 1 to 2 of 2
  1. #1
    dean is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    6

    sum in form footer

    Hi guys!

    I have this problem and I cant figure it out how many times I have tried it myself.



    I have this subform, and it has 4 textbox: three that is bound and the one that is unbound form.

    when I do calculations in the bound textbox, i can successfully arrive at the sum of textbox3 but when I sum the fourth unbound textbox, it give an error inside the textbox.

    Does it mean I cannot make a summation of an UNBOUND textbox?

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    You can not do a sum on an unbound field.

    You need to add the unbound field to your query and then bring it to the form.

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

Similar Threads

  1. Trouble Summarizing in Group Footer
    By Millerguitarworks in forum Reports
    Replies: 2
    Last Post: 12-07-2009, 06:06 AM
  2. Problems with SUM in Report Footer
    By bonetakc in forum Forms
    Replies: 1
    Last Post: 07-30-2009, 04:53 AM
  3. Totaling a value in group footer...
    By hodgy20 in forum Reports
    Replies: 0
    Last Post: 11-14-2008, 08:28 AM
  4. Need help with values in the footer
    By allochthonous in forum Reports
    Replies: 0
    Last Post: 03-03-2007, 08:20 PM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 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