Hello,
I really am sorry to bother you again so soon. I am running out of time and I can not get the FornatNumber() to work correctly.

This is my code:

  fCode = oRs("Code")
        cDescription = oRs("Description")
        rPays = oRs("Remedy_Pays")


%>

    <td><%= fCode %>&nbsp;</td>
    <td><%= cDescription%>&nbsp;</td>
    <td><%= rPays%>&nbsp;</td>

I need the rPays to display a number with two decimal points.
I have tried the code below among many others and I am not getting it.
      fCode = oRs("Code")
        cDescription = oRs("Description")
        rPays = oRs("Remedy_Pays")
           rPays = FormatNumber(rPays, 2)

generates this error:
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/MD_SearchReturn.asp, line 16

I am not able to find what I need and I am getting short on time.
If you can help me I would appreciate it.
Thanks!
dink

I pulled these off the web. I've used the standard one in my code wih success. This might give you a start until a guru can jump in...

Currency:
<% = Format( num, "Currency" ) %><BR>
Fixed:
<% = Format( num, "Fixed" ) %><BR>
Standard:
<% = Format( num, "Standard" ) %><BR>

generates output
Currency: $1,741,534.54
Fixed: 1741534.54
Standard: 1,741,534.54

I tried your suggestion in the code like this:
<td><%= fCode %>&nbsp;</td>
    <td><%= cDescription%>&nbsp;</td>
    <td><% = Format( rPays, "Currency" ) %>&nbsp;</td>
and got this error message:
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'Format'

/MD_SearchReturn.asp, line 52

I have pulled rPays from the db using
 rPays = oRs("Remedy_Pays")
this is the code for displaying the data on a webpage
<td><% = Format( rPays, "Currency" ) %>&nbsp;</td>
do I need create another variable? How do I get the value?

I just got it to work!!!!!
 <td><% = FormatCurrency(oRS("Remedy_Pays")) %>&nbsp;</td>
Thank you all!!!
dink