Compare recordsets

R

Ray Cacciatore

I have a form with two datasheets (two subforms in datasheet view). I need to
compare the data between them, they both are based on different queries but
the columns in both are the same. I need to indicate to the user if both
lists are the same. How can I do this?

Ray
 
R

Ray Cacciatore

I tried that but the wizard only tells you the unmatched data one column at a
time. I need to compare the entire two recordsets. Is there an easier way?
 
R

Ray Cacciatore

Hi Alex,

I still haven't figured this one out. I tried the unmatched query wizard, I
added joins for all fields and it did not work. I used two identical queries
and it returned a record. I'm assuming that if the two queries are identical,
the query wizard has to return no records, right? I keep getting one record.

Ray
 
Top