Formatting

Posted By: James at 00:57:35 on Friday the 5th of December 2003

I am using the following query to produce a virtual table. would like the output to have only 2 decimal points, as in standard currency. Is this possible and how. Here is what I am doing:

SELECT invoice.Amount - invoice.Payment * .0825 AS Balance FROM invoice

I am getting a return with ###.#### (four decimal points). Please help.

Thanks in advance, James

Reply to this comment

Name
Email
URL (optional)
Title of Comment
Comment
HTML Allowed:
a,code,strong,em
I would like to be e-mailed any response to my comment.