RE: find exact match or match those only few cents off
- From: Daryl S <DarylS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 Nov 2009 11:11:01 -0800
Hoachen -
Yes, this can be done, but I would worry about multiple matches occurring...
I also don't like the special characters in the field names...
To do what you want, make the query an inner join, but don't join on the
Dep$ = Return$ at all. Then add a field in your query for ABS([Dep$] -
[Return$]), and set the criteria to <=0.10.
You can test this, and then uncheck the 'Show' box for this new field if you
don't want to see it.
--
Daryl S
"hoachen" wrote:
Table1.
item# CustID Dep$
1234A 111 10.15
2554S 222 7.75
1232B 111 8.49
Table2
item# CustID Return$
1234A 111 10.15
1232B 111 8.47
Right now, I use Left join on all these fields (it have more fields but I
shortern it). But if the Cents (Table1 1232B have 8.49 and Table2 have 8.47)
did not match exactly then I would not be able to varify the item has been
return
Is there anywhere I can do like if match exact the same, then display or if
only one to ten cents different it will display also.
The above result will only display:
The result should be display below even though there were two cents
different:
1234A 111 10.15
1232B 111 8.47
I am not know much about IIF function. I believe it can do it, can anyone
show me how to accomplish this?
Thanks
- Follow-Ups:
- RE: find exact match or match those only few cents off
- From: hoachen
- RE: find exact match or match those only few cents off
- References:
- find exact match or match those only few cents off
- From: hoachen
- find exact match or match those only few cents off
- Prev by Date: Re: Multiple records in a query
- Next by Date: Re: Error in syntax
- Previous by thread: Re: find exact match or match those only few cents off
- Next by thread: RE: find exact match or match those only few cents off
- Index(es):
Relevant Pages
|
