Results 1 to 7 of 7
  1. #1
    Join Date
    May 2004
    Posts
    86

    Unanswered: Currency problem

    I have a query and a base a report of this query. I have a feild that shows a total. now i have numbers like 6840 now when i set it to currency it comes out 68,400.00 instead of $68.40 How can i get this to display correctly???


    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by petenyce105
    I have a query and a base a report of this query. I have a feild that shows a total. now i have numbers like 6840 now when i set it to currency it comes out 68,400.00 instead of $68.40 How can i get this to display correctly???


    Thanks
    Run an update query to divide the column by 100
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    May 2004
    Posts
    86

    Ok Made the query

    Now where do i / 100 where do i place this?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    UPDATE SomeTable SET SomeColumn=SomeColumn /100;
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    May 2004
    Posts
    86

    heres the database i made the query

    what i am trying to do is make my numbers the correct currency. i have a number 5500 and its returning 55,000 or 4506 i want 45.06 not 45,0006. I attached the database any help would be great... Please some guidance would be great


    Pete
    Attached Files Attached Files

  6. #6
    Join Date
    Apr 2004
    Posts
    41

    Question Where are these numbers?

    There is nothing in your database but 1 table and 1 query. There are no numbers in the table, only two text fields.

  7. #7
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    If you are just trying to display the number a different way then I would use the Format function. In your query add a field like:

    FormattedTotal:Format([Total]/100,"$#,##0.00")

Posting Permissions

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