Hello

I need some help with a report. Currently in the system if an account is more then a certain amount of days late they get a letter sent out. If account # MFS1000 has multiple invoices say invoicce169 is $3000 and invoice167 is $2000 they both show on the report. My question is, how do i take those invoices and add up there total so it just shows MFS1000 to show up as $5000

any help would be great

Thnks

have you tried a running sum?

http://www.access-programmers.co.uk/forums/showthread.php?t=56654

i am not sure a sum would work. Say the report has 50 accounts on them but only the MFS1000 account ony has 2 invoices, how would i get only those 2 invoices to add up and still display the other 49 accts

are you using a grouping on your report?

no grouping at all
just sorting acsending by cust name

if you set up some sort of grouping, then you would be able to sum based on the same MFS#

would you beable to give me a starting point on that??

here is a quick hint... not sure if this will point you in the right direction
http://office.microsoft.com/en-us/access/HA010345821033.aspx

can you post a sample of your DB?