|
| |
|
|
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
Posts: 257
From: Tampa Florida Tampa, FL USA
Status: offline
|
RE: Access db calculation displayed wrong - 3/29/2001 20:27:00
Try this page:
http://www.outfront.net/spooky/adv_drw_val.htmAnd specifically look for:
Formatting Currency <%=FormatCurrency(FP_FieldVal(fp_rs,"CurrencyField"),2)%>
------------------
Brian---
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
