Compare recordsets Ray Cacciatore 22.09.2006 15:52:01 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

Re: Compare recordsets "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 24.09.2006 07:44:06 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 "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in message news:D5E24044-8537-450A-AC8C-07FCF90BA6B7[ at ]microsoft.com... [Quoted Text] >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

Re: Compare recordsets Ray Cacciatore 25.09.2006 13:37:02 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" wrote: [Quoted Text] > 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 > > "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in message > news:D5E24044-8537-450A-AC8C-07FCF90BA6B7[ at ]microsoft.com... > >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 > >

Re: Compare recordsets "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 25.09.2006 14:22:35 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 "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in message news:E0780563-CAED-4C8A-ABEF-50F0FDC53AE9[ at ]microsoft.com... [Quoted Text] >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" wrote: > >> 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 >> >> "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in >> message >> news:D5E24044-8537-450A-AC8C-07FCF90BA6B7[ at ]microsoft.com... >> >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 >> >>

Re: Compare recordsets Ray Cacciatore 29.09.2006 19:33:01 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" wrote: [Quoted Text] > 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 > > "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in message > news:E0780563-CAED-4C8A-ABEF-50F0FDC53AE9[ at ]microsoft.com... > >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" wrote: > > > >> 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 > >> > >> "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in > >> message > >> news:D5E24044-8537-450A-AC8C-07FCF90BA6B7[ at ]microsoft.com... > >> >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 > >> > >> > >

Re: Compare recordsets "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 30.09.2006 14:39:58 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 "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in message news:840031EA-6A6C-43F4-8B8A-FA3A087A4DE6[ at ]microsoft.com... [Quoted Text] > 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" wrote: > >> 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 >> >> "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in >> message >> news:E0780563-CAED-4C8A-ABEF-50F0FDC53AE9[ at ]microsoft.com... >> >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" wrote: >> > >> >> 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 >> >> >> >> "Ray Cacciatore" <RayCacciatore[ at ]discussions.microsoft.com> wrote in >> >> message >> >> news:D5E24044-8537-450A-AC8C-07FCF90BA6B7[ at ]microsoft.com... >> >> >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 >> >> >> >> >> >>