Format database results column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to show an integer in my asp results column coming from access. I am
getting 6 decimal places currently. How do i rounf off in fp?

My query in access is formatted for 0 decimal places.
 
Same technique as in http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency
But change the format to
Format(myAmount,'#,##0') as Integerfield

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I need to show an integer in my asp results column coming from access. I am
| getting 6 decimal places currently. How do i rounf off in fp?
|
| My query in access is formatted for 0 decimal places.
 
Back
Top