[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