Results 1 to 5 of 5
  1. #1
    undee69 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    39

    #Error for "=Sum" control source

    hi there.



    I am having issue using the "=sum()" function for reports

    it is giving me #error on the report form.. I am using the following

    unitPrice=number
    qty=number

    I query them and have another column, Amount: [unitprice]*[qty]

    on the report form, i have another control named Total, which is not formatted, i set its control source as =Sum([Amount])

    When I run the report, the total just displays "#Error"
    Attached Thumbnails Attached Thumbnails Snapshot_2012-12-12_140303.png  

  2. #2
    SteveH2508 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Chelsea, London, England
    Posts
    117
    =Sum([unitprice]*[qty]) should work.

    You cannot reference another control for the sum - it is not like a spreadsheet formula.

  3. #3
    undee69 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    39
    I have already done that prior to posting this thread and still it gives me the error. Also =sum([unitprice]) and =sum([qty]) gives the same #Error

  4. #4
    SteveH2508 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2010
    Location
    Chelsea, London, England
    Posts
    117
    Are you putting it in the Page footer? It will not work there. Totals can only be calculated in Group footers.

  5. #5
    undee69 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    39
    Yes I am doing that in the page footer. I made it working now. I copied a working control from my other database. ^_^

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

Similar Threads

  1. Replies: 5
    Last Post: 06-25-2012, 02:06 PM
  2. Replies: 13
    Last Post: 01-11-2012, 09:44 PM
  3. Replies: 2
    Last Post: 11-04-2011, 02:45 AM
  4. Replies: 3
    Last Post: 03-21-2011, 05:29 PM
  5. "Group By" causes "ODBC--Call Failed" error
    By kaledev in forum Queries
    Replies: 1
    Last Post: 03-09-2011, 02:43 PM

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