Format an SQL string

G

Guest

Hello,

I have some code that has some SQL. This works fine and produces the
results in the usual query window. The data is mainly numbers and I would
like to format the results in the standard number format. At the moment
there are no commas and is at 16 decimal places which is not user friendly.

Can anyone help?

Thanks,

Martin
 
V

Van T. Dinh

Use the Format() function, posible in your SQL to format the output as
required.

You should post relevant code / SQL with your question so that potential
respondents have some clue of what you are doing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Excel Excel 2007 won't stop rounding down my formula results! 5
reduce queries by using code 2
Export SQL 1
Access shows duplicates in linked SQL View 2
DDL for INSERT/UPDATE with Decimal Formatting 3
Access Project SQL Import csv 4
Decimal point in bar chart and similar 1

Top