I'm using SQL Server 2008 R2 as backend database. I need to append a row to a table where the destination field is text (nvarchar) and the source field is float. The source field may contain zero, 1, or 2 decimal places. I need the destination, text field to always show the two decimal places, i.e., 12.3 expands to 12.30. If I write the Access query directly in Query Builder, I can designate the properties of the output field as fixed, 2 decimal places. However, in this case I need to generate the SQL code for the query dynamically in VBA, save it, and execute it. Is there a way I can tweak the properties of the output field in VBA to fixed, 2 decimals before running it, as if I had done this in query builder design mode?
Thanks, Eddie