MySQL Forums
Forum List  »  Microsoft Access

Re: Currency and Deciamal with Microsoft Access
Posted by: chriso
Date: July 30, 2004 10:46AM

Hello Michael,

to show decimal positions you can use the "format" function. This is an example from the manuel:

FORMAT(X,D)
Formats the number X to a format like '#,###,###.##', rounded to D decimals, and returns the result as a string. If D is 0, the result will have no decimal point or fractional part. mysql> SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
mysql> SELECT FORMAT(12332.1,4);
-> '12,332.1000'
mysql> SELECT FORMAT(12332.2,0);
-> '12,332'

Regards,

Christoph

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Currency and Deciamal with Microsoft Access
7130
July 30, 2004 10:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.