Results 1 to 7 of 7
  1. #1
    silverxx12 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    18

    Payt date tot.

    Hi



    i created a query for max date to show last date of payt then inner joined both name and date to original table to obtain lastdat and last payt via name

    Assuming i have done this correctly - is there a way to show also tthe total sum of all the paymentts in an additional coloumn ?

    tia

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You want the sum by name? In the query for max date also do a sum aggregate.
    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.

  3. #3
    silverxx12 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    18
    yes plz ideally i would like to see

    name - last date of payt - last payt - and total payts made so far by name

    the last date of payt and last payt i got as stated in the method above ( be glad to know other methods too ... always keen to learn :-) ) - just looking to show total payts so far in another column

    thnx for the help

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do you try what I suggested?
    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
    silverxx12 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    18
    so sry didnt read the rest of your comment :-(

    I assume you mean to put on the query for max date also an amount column with in the "group by" to qualify that with "Sum"

    please correct me if i misunderstood many thanks

    Also do i need to join the "aggregate sum amount" to the "amount" column like i did for name and date ?

    many thanks

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Yes, Sum column.

    Join on amount? No.
    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.

  7. #7
    silverxx12 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    18
    yes, thank you - will let you know if i have any problems.

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

Similar Threads

  1. Replies: 12
    Last Post: 04-26-2012, 04:01 AM
  2. Replies: 1
    Last Post: 12-12-2011, 06:32 AM
  3. Replies: 1
    Last Post: 12-07-2011, 01:02 PM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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