Another tables question

Results 1 to 2 of 2

Thread: Another tables question

  1. #1
    Renee G Guest

    Default Another tables question

    My code loops through the fields in my recordset and creates a column for each field. This works fine. I took it a step further and tried using a case select to format the currency column to right justified. No success. I think I used something like<BR> &#060;%if rs.fields(i).name = "curtotal" then%&#062;<BR> &#060;td align="right"&#062;<BR> &#060;%end if%&#062;<BR>I would really like to format the currency to a two digit decimal with a dollar sign, and would assume I place that code when I populate the rows using<BR> &#060;%if rs.fields(i).name = "curtotal" then%&#062;<BR> &#060;%format("curtotal",currency)%&#062;<BR> &#060;td align="right"&#062;<BR> &#060;%end if%&#062;<BR><BR>Thanks for your help!

  2. #2
    Ricardo Londe Guest

    Default RE: Another tables question

    You should try to use the FormatCurrency function. Use something like this:<BR>&#060;%=FormatCurrency( rs("curtotal"), 2, -1, 0, -1)%&#062;<BR><BR>I hope this helps.<BR>Ricardo Londe.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts