Results 1 to 4 of 4
  1. #1
    buckwheat is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2013
    Posts
    144

    Report Sum (I know it should be simple)

    Hi,

    I know this is probably too simple to ask, but here goes. I have one field on my report called "Amount." How do I get a sum of this field please?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    This is marked Solved, so presumably you found:

    =Sum(FieldName)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    buckwheat is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2013
    Posts
    144
    Yes, Thank you. I attempted to put the code in the page footer and wouldn't work, when I changed it to report footer, it then worked.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Yeah, that type of thing will work in a group footer or the report footer, but not in the page footer.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. simple agent/commission report
    By smil27 in forum Access
    Replies: 46
    Last Post: 07-06-2013, 02:06 PM
  2. how to generate this simple report in report ms access
    By learning_graccess in forum Reports
    Replies: 1
    Last Post: 11-26-2011, 02:10 PM
  3. Creating a simple report?
    By berni3883 in forum Reports
    Replies: 1
    Last Post: 03-29-2011, 12:31 PM
  4. Simple Report by Month
    By leejqs in forum Reports
    Replies: 3
    Last Post: 07-15-2009, 09:24 AM
  5. Probably a simple report question
    By gmurrie in forum Reports
    Replies: 1
    Last Post: 12-28-2005, 09:19 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