Adding the pennies correctly
From: Ian Brown <browni_at_globalnet.co.uk>
Date: 27 Jun 1999 18:31:59 GMT
Message-ID: <01bec0cb$bc6544c0$159793c3_at_default>
[Quoted] [Quoted] 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
Date: 27 Jun 1999 18:31:59 GMT
Message-ID: <01bec0cb$bc6544c0$159793c3_at_default>
[Quoted] [Quoted] 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 Received on Sun Jun 27 1999 - 20:31:59 CEST