Randall R Anthony
RRANTHON at sentara.com
Fri Apr 15 13:19:52 CDT 2005
I tried that, because the ErrorAmount is listed first in descending order, and the claimid is listed second with grouping, this suggestion did not resolve the problem. >>> cyx5 at cdc.gov 4/15/2005 1:23:02 PM >>> Create another grouping for the unique value; then show the detail. Sum up only the unique value and blow off the detail. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randall R Anthony Sent: Friday, April 15, 2005 1:18 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Using Sum to add total without duplicates <<Or are you saying that you want the duplicates to appear in the detail but not be totalled?>> Exactly. Because of the way the report is setup, I need to show the dupes because a remark column shows different meanings, but the ErrorAmount field is the same, and I only want a sum total of all the first instances of the ErrorAmount. >>> andy at minstersystems.co.uk 4/15/2005 1:09:21 PM >>> Randy I'd guess that the sum is only summing what's there, so are you saying you want duplicates suppressing from the report entirely, and thus from the totals? Or are you saying that you want the duplicates to appear in the detail but not be totalled? -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randall R > Anthony > Sent: 15 April 2005 16:48 > To: accessd at databaseadvisors.com > Subject: [AccessD] Using Sum to add total without duplicates > > > 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. > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com