Number formatting for database results

G

George Grech

Hello, I have a MS Access database in my FP 2003
website. I can successfully retrieve data from my
database using the Database Results Wizard. I an looking
up a Query(view only) and some of my columns are
numbers. I would like to set the decimal place to 3
places for all results but can't find how to set this
parameter in FP.
I have set the decimal places in my Query and Tables in
MS Access to 3 decimal places, when I view my query in
Access the results come to three decimall places.
Any help on resolving this issue in FP would be much
appreciated. thanx
 
T

Thomas A. Rowe

Use FormatNumber

<%=FormatNumber(fp_rs("fieldname"),3)%>

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

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