Retrieving Certain 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)..
the values in this field would only match one other record i the database.
The other field (TotalScore) would have a different value and 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
 
Ray,

I don't have time to construct the SQL or the data to test it, but the
theory would be to construct a UNION query that would include the data you
need from both tables.
Then a Totals SELECT query based on the Union that would group on the call
id and score. The result should be that where the scores are the same for
both tables, there would be only one record. There would also only be one
record when a call id existed in only one table. Where the call ids match
and the scores are different, there would be 2 rows.
 
Back
Top