ExecuteSQL drops zeros after decimal when extracting price information...
I am using the following calcuation to extract pricing information and display in columns.
ExecuteSQL ( "SELECT Category, Sum ( Cost ) FROM Renovation GROUP BY Category ORDER BY 2 DESC" ; Char (9) ; "" )
My problem is that SQL drops any zero's after pricing. Thus they will not line up properly. Does anyone know how to keep the zeros?
Please see attached photo which illustrates the problem. Notice that the top price has no ".00" after it causing it not to line up...