[AccessD] Using Sum to add total without duplicates

Randall R Anthony RRANTHON at sentara.com
Fri Apr 15 10:47:43 CDT 2005


Hey lIsters,
My first post with my new address and I think it's easy, I just have to
get up to speed.  I have a report that does a sum([ErrorAmount]) at the
footer.  ErrorAmount is in the detail line, however there are duplicates
which are incorrectly being added to the sum([ErrorAmount]).  Any
suggestions?

Thanks,
Randy.



More information about the AccessD mailing list