Calculating sum of multiple records to display 1 total sum

From: df2000 (df2000_at_discussions.microsoft.com)
Date: 10/07/04 

Date: Thu, 7 Oct 2004 13:55:01 -0700

Acct # Amt Due
123456 15
123456 20
445544 11
445544 6
789888 5
099999 4

I want to run a query that finds the total sum of each account # and
displays the record ONLY 1 time. So I want to display:

Acct # Amt Due
123456 35
445544 17
789888 5

etc.

Relevant Pages

  • Re: Calculating sum of multiple records to display 1 total sum
    ... Duane Hookom ... MS Access MVP ... > Acct # ... Amt Due ...
    (microsoft.public.access.queries)
  • match,lookup or vlookup????
    ... Amt ... or match commands) that use the amount of the second list with there ... corresponding acct # but if there is any acct match with the first list use ... The rest accts should have the amount from the second list. ...
    (microsoft.public.excel.misc)
  • Enter new defaults in a form before data entry?
    ... I have a form for my Acct dept to update our order ... information with check number and amt. ... number and date 1 time before entering info for a check ... Laura ...
    (microsoft.public.access.forms)
  • Re: select query
    ... create table t (acct int, dramt int, cramt int) ... select acct, case when amt> 0 then amt else 0 end dr_amt, ...
    (microsoft.public.sqlserver.mseq)
  • Re: Change to Users Name on Stand Alone PC WXP Pro SP2
    ... Go to the control panel/users and delete any Edna accounts. ... simply logon to the owner account as you normally do. ... that's the view in the User Accts window. ... You must create at least one computer administrator acct before u can ...
    (microsoft.public.windowsxp.general)