Subtotal for same accounts

[Guest]

I have a large file with acct #s, dates, and $s. What is the easiest way to
group the same acct #s and total the $s to get one acct # and total amount?
Thank you.

 

[[MVP] S.Clark]

Select Acct, Sum(Amt) from tablename
GROUP BY Acct


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html