Number formatting for database results

  • Thread starter Thread starter George Grech
  • Start date Start date
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
 
Use FormatNumber

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format database results column 1
Access stripping decimal places in query 1
Frontpage results - Number rounding issue 22
Format a calculated result in FP 3
Database results format field 2
Picture Images in Access Database / Frontpage .asp webpage 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Database Results Wizard greyed out 17

Back
Top