Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    8

    Question Unanswered: Trying to compare two $ amounts

    I've got two columns I'm trying to compare on my report, and only return records where there's a difference. This will allow the user to see inconsistencies.

    The first column is one - to - one with the main table, and the other column is a one - to - many with the main table, and I have to divide this second column by 1000 in order to compare the two.

    I can visually see the dollar amounts are the same (or different), but can't get the report to see that. Both totals are per PK in the main table. The first column is simply the value of the column, where the second is the summation / 1000.

    Any ideas are welcome!

    Thanks!

  2. #2
    Join Date
    Jul 2005
    Posts
    50
    More info ... describe the tables you are drawing from (name of tables, any union query, datatypes for the columns that hold the amounts) and ... well ...

    ... why do you need to do any division to determine the column values are different? Your problem isn't connecting for me...

  3. #3
    Join Date
    Jul 2005
    Posts
    8

    Smile Thanks.....finally figured it out

    Thanks mlbuie!

    I figured the issue out with a round().

    The reason I had to /1000 is that one field is entered in K dollars, and one in whole dollars.

    Thanks for the reply!

Posting Permissions

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