Format number

[Jeff]

I almost hate to post this here, because it is so basic. But my mind isn't
the same as it used to be.

I am using asp with access db on ms server

total_score is my field from a table within the db., I wish to format this
to show commas, but no decimal. Rounding in other words. What is the code
for this please, can someone show me?

i know it is something like var = format(total_score,0,0) or something to
that effect.
Please don't make me feel like too much like a complete idiot for not
remembering this..lol
Any help would be appreciated
Bam

 

[Jeff]

The weird thing is, it is formated correctly within the Access DB, and the
commas show there, but the display on the page doesn't show the commas. See
here:
http://www.gig-golf.com/GIG/ladder/current.asp

 

[Evertjan.]

Jeff wrote on 11 dec 2005 in microsoft.public.inetserver.asp.general:
[please do not toppost on usenet]

The weird thing is, it is formated correctly within the Access DB, and
the commas show there, but the display on the page doesn't show the
commas. See here:
http://www.gig-golf.com/GIG/ladder/current.asp

You mean, you want to have a thousands seperator with commas?

That depends on your regional settings and do:

<%=formatnumber(myNumber,0)%>

 

[Jeff]

Jeff wrote on 11 dec 2005 in microsoft.public.inetserver.asp.general:
[please do not toppost on usenet]

The weird thing is, it is formated correctly within the Access DB, and
the commas show there, but the display on the page doesn't show the
commas. See here:
http://www.gig-golf.com/GIG/ladder/current.asp

You mean, you want to have a thousands seperator with commas?

That depends on your regional settings and do:

<%=formatnumber(myNumber,0)%>

Thanks.... all I can say is DOH!!!
Bam