Average in select statement becomes Text ???
"Gert Blij" <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
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