Brian
|
| Posted: 04/19/2002, 11:26 AM |
|
I've tried formatting the results from a query using VB before show
fldbudget_utilization = formatnumber(fldbudget_utilization)
fldbudget_utilization = formatpercent(fldbudget_utilization, 0)
But still get 70.999999 displayed on the page. Can anyone help me get this working?
Thanks
|
|
|
 |
Andrew B
|
| Posted: 04/19/2002, 4:48 PM |
|
http://msdn.microsoft.com/library/default.asp?url=/libr...ormatnumber.asp
|
|
|
|
Brian
|
| Posted: 04/29/2002, 8:18 AM |
|
I've tried VB beforeshow FormatNumber(avg_spent[,-1 [,-1 [,-1 [,-1]]]]) but still get more digits than I need.
Any more suggestions
|
|
|
|
Nicole
|
| Posted: 04/30/2002, 2:59 AM |
|
Brian,
try this code in Before Show:
fldfield_name = formatnumber(fldfield_name, 2)
this particular example will show 2 decimal digits.
|
|
|
|
|
