429,564 Members | 810 Online
Need help? Post your question and get tips & solutions from a community of 429,564 IT Pros & Developers. It's quick & easy.

# Trying to run expression for rounding???

 P: 37 Good afternoon gents, I'm trying to capture a dollar amt for a specific table running a link from another table. So I have the first [action_amt] and the second [action_amt], and I'm trying to capture all the payments from the first action [action_amt] that >= the second [action_amt], however there are some [action_amt] from the first table that have 2 digits, therefore the expression won't capture it. What can I do? Example: first action_amt = \$25.34 and second amt is \$25.00, I miss that \$25.00 payment for only a couple of cents. All your help is greatly appreciated. Jan 14 '08 #1
3 Replies

 Expert 2.5K+ P: 2,653 Hi, matrekz. I guess you are talking about table join. And so far you have something like Expand|Select|Wrap|Line Numbers SELECT ..... FORM t1 INNER JOIN t2 ON t1.[action_amt] = t2.[action.amt];   I guess you mean - consider two values to be equal if differense between them is less than some threshold level (0.5 in the following example). Expand|Select|Wrap|Line Numbers SELECT ..... FORM t1 INNER JOIN t2 ON Abs(t1.[action_amt]-t2.[action.amt]) < 0.5;   Regards, Fish Jan 15 '08 #2

 P: 37 Worked out, thanks a million! Jan 15 '08 #3

 Expert 2.5K+ P: 2,653 Not a problem. Good luck. Jan 15 '08 #4