+ Reply to Thread
Results 1 to 2 of 2

sum multiple fields in access Report

  1. 05-01-2021, 02:11 PM #1
    kirana2014
    kirana2014 is offline
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    203

    sum multiple fields in access Report

    Dear All,

    Please help with sum formula:
    I would like to add total per name op the product
    See picture.

    Thank you in advance
    Attached Images Attached Images
    Last edited by kirana2014; 05-07-2021 at 09:55 AM.
    Reply With QuoteRegister To Reply
  2. 05-01-2021, 04:12 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,851

    Re: sum multiple fields in access Report

    Assume your table is named TblOrder. Here is the SQL statement you require.
    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Slicer report connection for dissimilar fields
    By johnnylzep in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-07-2018, 12:44 PM
  2. Adding a password to the Report Filter Fields
    By tryingtoexcelatexcel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-05-2017, 11:38 AM
  3. Access, trim all values in all fields and multiple tables
    By student1976 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2012, 12:13 AM
  4. Creating report with multiple records/fields. Simple Solution?
    By mooshu22 in forum Excel General
    Replies: 3
    Last Post: 02-22-2011, 09:22 PM
  5. sort & report multiple criteria from multiple columns & report back a count to one ce
    By Bohddisatva in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-22-2009, 05:26 PM
  6. Access - Creating report requiring password/username for multiple people
    By shadestreet in forum Access Tables & Databases
    Replies: 2
    Last Post: 04-25-2009, 04:56 AM
  7. Creating an automatic report from multiple filtered fields from multiple worksheets
    By julie74 in forum Excel General
    Replies: 0
    Last Post: 04-17-2009, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1