Query to retrieve records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working out of two audting databases for a call center with the same
information except for different scores. I've built macros to import data
from both databases into a thrid database for analysis. Is there a statement
i can put in the criteria of a query to find those records (from both
databases) with the same information but only display the ones that have
different scores?

For instance one of the fields has a set of unique numbers (Call ID field)
which can be used for the "Same" statement and the other field (TotalScore)
can be used in the 'IF" statement to extract those with different scores for
further analysis. I think that's the basics.. any help would be appreciated.

Ray
 
You might check the tables to see if they both have all the calls first.

SELECT TableA.CallID, TableA.Score, TableB.Score
FROM TableA INNER JOIN TableB ON TableA.CallID = TableB.CallID
WHERE (((TableB.Score)<>[TableA].[Score]));
 
Back
Top