Please ignore this email, I found the reason. (Upgrading from MySQL 4 to 5rc needs a lot more preparation than I thought. No such thing as a Q&D upgrade.)
Why in the following statement: SELECT `Date`, `Hole`, AVG( `Score` ), AVG( `Fairway` ), AVG( `Pitch` ), AVG( `Bunker` ), AVG( `Chip` ), AVG( `Putt` ), AVG( `Penalty` ), COUNT( `Score` ) FROM `GolfAnalysis`.`analysis` `analysis` GROUP BY `analysis`.`Date`, `analysis`.`Hole` do all the AVG fields become Text fields in the result iso Numeric fields? TIA Gert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
