ASP - how to put comma in DW

[Newsgroup_User]

hii there

using ASP and MS Access

I am retrieving data from a number field like - "89000"

this field stores the price of the product

I wouuld like to put a comma after 2 digits like 89,000

and would like to put comma after 3 digits like 485,000

teh recordset when receives the data only pull the complete text in the row
how can i put a comma after i receive from the data something like this
89,000 or 485,000 etc.

thanks

[Newsgroup_User]

You can format the number field in your access database. in table design
view.
Dave
"Techy" <anwar@clickbahrain.com> wrote in message
news:fom7f9$6l7$1@forums.macromedia.com...
> hii there
>
> using ASP and MS Access
>
> I am retrieving data from a number field like - "89000"
>
> this field stores the price of the product
>
> I wouuld like to put a comma after 2 digits like 89,000
>
> and would like to put comma after 3 digits like 485,000
>
> teh recordset when receives the data only pull the complete text in the
row
> how can i put a comma after i receive from the data something like this
> 89,000 or 485,000 etc.
>
> thanks
>
>

[Newsgroup_User]

"Techy" <anwar@clickbahrain.com> wrote in message
news:fom7f9$6l7$1@forums.macromedia.com...
> hii there
>
> using ASP and MS Access
>
> I am retrieving data from a number field like - "89000"
>
> this field stores the price of the product
>
> I wouuld like to put a comma after 2 digits like 89,000
>
> and would like to put comma after 3 digits like 485,000
>
> teh recordset when receives the data only pull the complete text in the
> row how can i put a comma after i receive from the data something like
> this 89,000 or 485,000 etc.

Select the field in your page and then look at the Bindings Panel - there
should be a down-arrow in the Format column - take a look at the options
there; there might be one that suits what you need

[Newsgroup_User]

hi baxter...

can you tell me how to do that in access please....

i am not able to figure it out

thanks

[Newsgroup_User]

Sure, open your access database pick your table with the number field you
want to format, Click the triangle with the pencil next to it (Design View)
Under data type
Make sure its a number then in field properties click in the format field a
dropdown box will show up click the drop down and select the format display
layout you want for your number to show up in the field. (standard) is what
you probably want.
Dave
"Techy" <anwar@clickbahrain.com> wrote in message
news:fou8q3$5ct$1@forums.macromedia.com...
> hi baxter...
>
> can you tell me how to do that in access please....
>
> i am not able to figure it out
>
> thanks
>
>