Compare recordsets

[Guest]

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

 

[Alex Dybenko]

Hi,
perhaps you can just use 2 subforms underlying queries to find unmatched
data, try to use "find unmatched data query wizard" to get such query

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

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?

 

[Alex Dybenko]

The query, which wizard made, has one join between source queries, if you
add joins for all fields you need to compare and also add criteria for there
fields - then you achieve the goal

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

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

 

[Alex Dybenko]

Hi Ray,
the idea that you have to have Left joins between queries and for criteria
you have to put field1 is null or field2 is null or ..etc for each field in
a join

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com