I currently have the following executeSQL results below.
I'd like to format the number to 2 decimal places. For now I'm only concentrating on the first field containing the number 2. I'd like to return the value, 2.00.
I've tried formatting the field and that didn't work.
I used the following code:
ExecuteSQL ( "select sum(c_FinalLaborHrsUsed_Line) FROM jobs_PRODLABORCOSTS Where JobID_FK=? group by ContactID_FK"; ""; ""; GetAsText(ID) )
But when I try to use SQL functions like Decimal or Cast, I did not get the desired results:
Any help would be appreciated. Thank you for your help.