"Jeff" <gig_***@adelphia.net> wrote in message
news:nsadnZwlN-84wAbenZ2dnUVZ_v-dnZ2d@adelphia.com...
>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" <gig_***@adelphia.net> wrote in message
> news:nsadnZwlN-84wAbenZ2dnUVZ_v-dnZ2d@adelphia.com...
>>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

"Evertjan." <exjxw.hannivo***@interxnl.net> wrote in message
news:Xns97295C6C8ED9eejj99@194.109.133.242...
> Jeff wrote on 11 dec 2005 in microsoft.public.inetserver.asp.general:
>> "Jeff" <gig_***@adelphia.net> wrote in message
>> news:nsadnZwlN-84wAbenZ2dnUVZ_v-dnZ2d@adelphia.com...
>>>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
>
> [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)%>
>
> --
> Evertjan.
> The Netherlands.
> (Replace all crosses with dots in my emailaddress)
>