Re: Displaying data to 2 decimal points

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Guy Hocking (guy_at_ANTIbradflack.SPAMcom)
Date: 03/07/04 

Date: Sun, 7 Mar 2004 17:15:25 -0000

Hi,

Thanks for the response -

Any examples of the functions in my scenario?

Cheers 

--
G
www.bradflack.com
Please remove ANTI and SPAM from my
email address before sending me an email.
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:O9rupTGBEHA.916@tk2msftngp13.phx.gbl...
> Guy Hocking wrote:
> > Hi there,
> >
> > I have an ASP/SQL 7 application that rips data from SQL Views onto an
> > ASP page.
> > I have a money column in a SQL table that contains money income
> > values.
> >
> > When data is input to this field it needs to be displayed as money
> > (to 2 decimal places - 10.00 or 7.60)
> > However, this only seems to be occurring when the user puts in the
> > extra 0, and if 7.6 is entered, it is still displayed as 7.6
> >
> > I need all data to be displayed as money values (and it is selected
> > as money in SQL), so is there any way (either in the table design,
> > View design, or display on the ASP page) to get the data to 2 decimal
> > places, no matter what?
> >
> > Thanks for you help, in advance
>
> Use one of these vbscript functions:
> FormatCurrency
> FormatNumber
>
> HTH,
> Bob Barrows
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Relevant Pages

  • Re: Displaying data to 2 decimal points
    ... > ASP page. ... > I have a money column in a SQL table that contains money income ... or display on the ASP page) to get the data to 2 decimal ...
    (microsoft.public.inetserver.asp.general)
  • Re: Displaying data to 2 decimal points
    ... > ASP page. ... > I have a money column in a SQL table that contains money income ... or display on the ASP page) to get the data to 2 decimal ...
    (microsoft.public.sqlserver.setup)
  • Re: Displaying data to 2 decimal points
    ... >> I have a money column in a SQL table that contains money income ... or display on the ASP page) to get the data to 2 decimal ... This email account is my spam trap so I ...
    (microsoft.public.sqlserver.setup)
  • Displaying data to 2 decimal points
    ... I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP ... I have a money column in a SQL table that contains money income values. ... display on the ASP page) to get the data to 2 decimal places, ...
    (microsoft.public.sqlserver.setup)
  • Displaying data to 2 decimal points
    ... I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP ... I have a money column in a SQL table that contains money income values. ... display on the ASP page) to get the data to 2 decimal places, ...
    (microsoft.public.inetserver.asp.general)