Results 1 to 5 of 5
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Add totals for each unique number

    Hi,

    I have split form with 2 unique PESEL fields:

    Click image for larger version. 

Name:	QryNumber.png 
Views:	15 
Size:	26.5 KB 
ID:	30411

    Total sum is 7000 thousends but i want to show total sum for PESEL 211812779 (6000 zł)
    and separately for PESEL 211000310 (1000 zł)



    It is possible do it somehow in Access?

    Please help,
    Best wishes,
    Jacek

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you need a parent/child form.
    the child subform will show ONLY records of the parent ID.
    then the subform can show the total for K_ID 220.
    in the subform footer ,put a blank text box. Set the source of the textbox to =SUM(Kwota)

    this will give you the total.

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Ok thank you !

    I will check it!

    Best Wishes,
    Jacek Antek

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This is what reports using Sorting & Grouping features with aggregate calcs are for. Report allows display of raw data as well as grouped and summarized info.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Thank you June,

    so maybe the best option is to use the report here,

    Best Wishes,
    Jacek

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

Similar Threads

  1. Replies: 2
    Last Post: 10-12-2016, 05:48 PM
  2. How include a unique number on a report?
    By Bazsl in forum Reports
    Replies: 2
    Last Post: 06-24-2016, 02:59 PM
  3. Replies: 3
    Last Post: 02-24-2014, 02:19 PM
  4. Query Criteria: Unique Number
    By efleming in forum Access
    Replies: 1
    Last Post: 05-24-2011, 03:16 PM
  5. Auto Unique Number on every REPORT
    By imvineet in forum Access
    Replies: 3
    Last Post: 09-09-2010, 08:08 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