Access db calculation displayed wrong (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Guest -> Access db calculation displayed wrong (3/28/2001 21:31:00)

I have created a db query in Access 2000 that has divsion calculations. Let's use 10 divided by 3. In the Access query, I can limit the decimal places to two. But when I display the db query results, using Frontpage 2000, it carries it out to 15 decimal places!

Help!




Bnugent -> RE: Access db calculation displayed wrong (3/29/2001 20:27:00)

Try this page:
http://www.outfront.net/spooky/adv_drw_val.htm

And specifically look for:
Formatting Currency

<%=FormatCurrency(FP_FieldVal(fp_rs,"CurrencyField"),2)%>

------------------
Brian---




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625