Re: Adding the pennies correctly
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Sun, 27 Jun 1999 21:28:06 GMT
Message-ID: <GHwd3.30786$eF3.11721_at_news.rdc1.nj.home.com>
Date: Sun, 27 Jun 1999 21:28:06 GMT
Message-ID: <GHwd3.30786$eF3.11721_at_news.rdc1.nj.home.com>
Maybe you have some orphan records that are not hooked to any District. Did you have to do a join to bring in district?
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Ian Brown wrote in message <01bec0cb$bc6544c0$159793c3_at_default>...Received on Sun Jun 27 1999 - 23:28:06 CEST
>I have run two queries on a 5.8m record table. One verifies that the sum of
>the amount field [NUMERIC (14,2)] is £0.00. When I add a "District" field
>to the output and add GROUP BY the sum of the individual District totals is
>£0.03
>
>Can anyone tell me what is going on and, more importantly, how to properly
>report the District totals for a table that is in balance?
>
>Thanks in advance.
>
>Ian Brown
>
>