Results 1 to 3 of 3

Thread: Tolerance Match

  1. #1
    Join Date
    Jun 2010
    Posts
    2

    Question Unanswered: Tolerance Match

    Hi,

    I would like to know how to create using vba or query to match amount between table1 and table2 with a tolerance of 10 cent.

    Example (Table1)
    456,566.10
    20.56
    785,156.90

    Example (Table2)
    456,566.10
    20.57
    785,156.91

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You could use the Between operator (... x between y-10 and y+10 ...)
    Have a nice day!

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    You might be able to round the values to the nearest tenth of a cent and then join on the values. It would be 100% perfect but maybe you can think of something that will get closer.

Tags for this Thread

Posting Permissions

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