How to use float in SQL for amount
Dear,
I have a field called T_Amount data type is float,
e.g= T_Amount=11800
When i make formula in query (11800/24)*35.25=17331.25
but actually if i make in calculator (11800/24)*35.25=17331.24999
i want this full figure.
Is i need to change the data type?