Access Database

Results 1 to 3 of 3

Thread: Access Database

  1. #1
    Rashi Guest

    Default Access Database

    Hi,<BR> I am using ASP and i am getting information from access database and i have a column called amount in it which is of currency datatype and now when i get that information, i want to display amount in some particular format.<BR>like if Amount is 2000<BR>i want to display it as 2,000.00<BR>I tried to Use CCur(amount), but it didn&#039t work. Is there anyone who could help me in this Please?<BR>Thanks <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Database

    This should work...<BR><BR>FormatCurrency(amount)

  3. #3
    Rashi Guest

    Default RE: Access Database

    Erica, Yes It worked. Thank you very much. Highly Appreciate it.<BR>Thanks

Posting Permissions

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