[AccessD] Using Sum to add total without duplicates

Andy Lacey andy at minstersystems.co.uk
Fri Apr 15 12:09:21 CDT 2005


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
> 
> 




More information about the AccessD mailing list