Finding different records

[nayfeh]

Hi,

Have a simple question...i think

I have 2 tables, each with the fields CustNbr, LtrRate, StopRate. Now, I've joined these 2 tables in a 1-1 relationship. What I would like to do is have 2 queries:

(1) To find the all customers where LtrRate isn't the same from one table to the next.

(2) Same, but for StopRate.

So, for example

Table A: Table B:
CustNbr LtrRate StopRate | CustNbr LtrRate StopRate
1 50 100 1 50 100
2 50 100 2 25 50

My query would show only the 2nd record.

Thanks for your help.
TN

 

[WildHare]

In a query, try a criteria in [TableB]![LTRRATE] like this:

<> [TableA]![LtrRate]

You need to pick one table as your 'base', and one as your comparator. Put the fields from your base table in the query. Use the fields from your comparator table as criteria examples.

Make sure, if you do more than one field at a time, you put the &quot;<> Other-guy&quot; criterias on separate OR ROWS of the query, or you probably wouldn't get ANY records at all.

Jim



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm