By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,564 Members | 810 Online
Bytes IT Community
+ Ask a Question
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???

matrekz42
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
Share this Question
Share on Google+
3 Replies


FishVal
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
  1. SELECT ..... FORM t1 INNER JOIN t2 ON t1.[action_amt] = t2.[action.amt];
  2.  
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
  1. SELECT ..... FORM t1 INNER JOIN t2 ON Abs(t1.[action_amt]-t2.[action.amt]) < 0.5;
  2.  
Regards,
Fish
Jan 15 '08 #2

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

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

Post your reply

Sign in to post your reply or Sign up for a free account.