FP 2003 Data Results Formating Returned Values

[Pat]

First off I am new to FrontPage. I have done some very small pages, but
nothing that interfaces with a database until now.

I have a web page that is a front end to an access database table that is a
log of Purchase Orders. The problem I am having is the values in the
database are defined as Currency with 2 decimal positions. But the values
returned are not in the same format. The have 3 positions past the decimal
in some cases. Is there a way to format the returned values? Everything I
see in the help files points to SharePoint, which we do not have.

Thanks in advance.

 

[Pat]

I was able to find the answer. Just incase anyone is looking it is using the
format(element, '$#,#00.00) as NewVar in the select statement.