GROUP BY and SUM problem - More

[Gunnar Swan]

When I use COUNT, MIN, MAX or AVG, the functions work.
Only with SUM does it fail.
I changed the field type to FLOAT. Still broke.
I upgraded from 1.9.6 to 1.9.7 . Still broke.

Any ideas ?

------- Start of forwarded message -------
From: Gunnar Swan <GunnarSwan at PracticeToPass.com>
To: Valentina List <Valentina at lists.macserve.net>
Subject: GROUP BY and SUM problem
Date: 2/26/03 11:44:58 AM


I'm having a problem with SUM.
The fields I SUM are defined as #kTypeUShort

The following SQL produces Null, where it should give me a SUM of values

SELECT 
COUNT(fldResponseDate), 
 SUM(fldCorrectCount), 
 SUM(fldIncorrectCount), 
 SUM(fldSkippedCount) 
FROM tblChartData 
GROUP BY fldResponseDate 
ORDER BY fldResponseDate 

-- [[2, <Null>, <Null>, <Null>], [2, <Null>, <Null>, <Null>]]

This SQL shows that there is data to SUM.

SELECT 
 fldResponseDate, 
 fldCorrectCount, 
 fldIncorrectCount, 
 fldSkippedCount 
FROM tblChartData 
ORDER BY fldResponseDate "

-- [[20030224, 2, 13, 5], [20030224, 2, 13, 3], [20030225, 4, 11, 6], [20030225, 3, 12, 6]]


What am I doing wrong ?

Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses

-------- End of forwarded message --------


Best Regards,
Gunnar Swan
http://www.PracticeToPass.Com
Software Built For Statutory Courses