Compare recordsets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray Cacciatore - 22 Sep 2006 16:52 GMT

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

Reply to this Message

Alex Dybenko - 24 Sep 2006 08:44 GMT

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

Signature

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

>I have a form with two datasheets (two subforms in datasheet view). I need
>to
[quoted text clipped - 4 lines]
>
> Ray

Reply to this Message

Ray Cacciatore - 25 Sep 2006 14:37 GMT

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?

> Hi,
> perhaps you can just use 2 subforms underlying queries to find unmatched
[quoted text clipped - 8 lines]
> >
> > Ray

Reply to this Message

Alex Dybenko - 25 Sep 2006 15:22 GMT

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

Signature

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

>I tried that but the wizard only tells you the unmatched data one column at
>a
[quoted text clipped - 14 lines]
>> >
>> > Ray

Reply to this Message

Ray Cacciatore - 29 Sep 2006 20:33 GMT

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

> 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
[quoted text clipped - 18 lines]
> >> >
> >> > Ray

Reply to this Message

Alex Dybenko - 30 Sep 2006 15:39 GMT

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

Signature

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

> Hi Alex,
>
[quoted text clipped - 36 lines]
>> >> >
>> >> > Ray

Reply to this Message