Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

How To Get The Sum Of Records In A Report In Microsoft Access 2003

Microsoft Access 2003 Report Sum Microsoft Access 2003 Sum records

  • Please log in to reply
1 reply to this topic

#1 Frapps

Frapps

    CC Lurker

  • New Member
  • Pip
  • 8 posts
  • Location:Philippines
  • Programming Language:C, Java, C++, C#, (Visual) Basic, JavaScript, PL/SQL, Visual Basic .NET
  • Learning:PHP, Python, Perl, Ruby, Delphi/Object Pascal, Lisp, Pascal, Fortran

Posted 10 May 2012 - 07:50 PM

The report we are trying to make will get the sum of all total loan amounts. But whenever we click the Create report button we made, the report displays a prompt which asks for a value, and the sum of totals that appear in our report becomes (the number of entries in the records * the number entered in the prompt). What we need to know is how to make the report show the sum of the totals and not the value*value.

Attached Thumbnails

  • Totals.PNG

  • 0

#2 kernelcoder

kernelcoder

    CC Devotee

  • Expert Member
  • PipPipPipPipPipPip
  • 990 posts
  • Location:Dhaka
  • Programming Language:C, Java, C++, C#, Visual Basic .NET
  • Learning:Objective-C, PHP, Python, Delphi/Object Pascal

Posted 10 May 2012 - 10:03 PM

-- Right click on your field object (on footer) --> Click "Edit Total Running Field" in context menu
-- In the wizard, select the db field on which you want the sum operation (Red Bold in the attached image)
-- Select 'sum' from the 'Type of Summary' combobox.

Look at the image for details.
vb_report.PNG
  • 0





Also tagged with one or more of these keywords: Microsoft Access 2003, Report Sum, Microsoft, Access, 2003, Sum, records

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download