Decimal places in data

[Ian]

I wonder if anyone can help. I have a FP page that collects data from an
Access database using the Database connector. This works fine. The data
returned does not allow you to change the number of chars after a decimal
place, e.g. 111.10 is 111.1. Does any body know a way of making FP include
the '0' into the value.

Many thanks

Ian

 

[Thomas A. Rowe]

Enter the following on your page where you want it displayed in HTML view

<%=FormatNumber(recordset("Fieldname"),2)%>

Replace recordset and fieldnaem with your values.
The 2 indicates the number of decimal places.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Ian]

Thomas,

Many thanks for your help, one minor question. Where can I find the
recordset value ?

Regards

Ian

 

[Thomas A. Rowe]

If you are using the FP database component, it would be something like
fp_db, I think, I never use it.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================