Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: sum

Re: sum

From: Paul <paul_at_not.a.chance.ie>
Date: Fri, 5 Dec 2003 13:50:10 -0000
Message-ID: <MPG.1a3a9d71f9fc7ee8989830@news1.eircom.net>

stermic_at_gw.co.jackson.mo.us says...

> i'm trying to run a crystal report with a sum of a certain column of
> dollar amounts. the problem is that there are certain instances where
> some of the records are duplicated and unfortunately the duplicated
> dollar amount is added into the total at the end. i'd like to know how
> to prevent this from happening.

Show us the SQL statement that you are running. Would a DISTINCT clause help?

Paul...

-- 

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.
Received on Fri Dec 05 2003 - 07:50:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US