hi,
i tried to format recordset, but '#' is causing syntax error
sSQL = "SELECT [BOOM], Format([volume],"#,##0.000") AS BVolume, Format([total],"Standard") AS BValue FROM qLogs_Inventory;"
is # a special character for visual basic? how to make it work?
original, unformated and working sql
sSQL = "Select [boom], [volume], [total] From qLogs_Inventory;"
thanks
i tried to format recordset, but '#' is causing syntax error
sSQL = "SELECT [BOOM], Format([volume],"#,##0.000") AS BVolume, Format([total],"Standard") AS BValue FROM qLogs_Inventory;"
is # a special character for visual basic? how to make it work?
original, unformated and working sql
sSQL = "Select [boom], [volume], [total] From qLogs_Inventory;"
thanks