Date: Fri, 5 Dec 2003 13:50:10 -0000
> 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?
-- plinehan x__AT__x yahoo x__DOT__x com C++ Builder 5 SP1, Interbase 126.96.36.199 IBX 5.04 W2K Pro Please do not top-post.Received on Fri Dec 05 2003 - 14:50:10 CET