SUM or TOTAL in sql are int or float ?

[gapi]

Hi all why my query aggregate by SUM return me a integer value ? How can retrieve FLOAT instead ?

tnx

 

[Ricky D]

Can you post the sql please. Sums I do on float fields return floats.

Regards Ricky

 

[gapi]

this is my query:

MainQuery = "SELECT TOTAL(scadenze.col10) as totFattura, ditte.col2 As NOMEDITTA, scadenze.col4 " & _
    " FROM scadenze " & _
    " INNER JOIN ditte ON scadenze.col4= ditte.col1" & _
    " WHERE scadenze.col3=" & QUOTE & ccode & QUOTE & _
    " GROUP BY NOMEDITTA"

If I query single field (col10) it return value with commas, in SUM case not :BangHead:

 

[Erel]

The result of total(x) should be float. See this link: SQLite Query Language: Aggregate Functions