Hi Prasath, Both table data heading description is not matching except "MATCH" field. Also no. of column is not same. because of this two reasons, it is difficult to combine respective content with unmatch datas.
If you rectify above, we can bring all information. Regards, Maries. On Mon, May 2, 2011 at 5:36 PM, Prashant <pawleprash...@gmail.com> wrote: > Dear Maries, > > Thanks a lot, for help. Is it possible to get all information from > original > tables for these unmatched items > > Regards, > > Prashant > > > -----Original Message----- > From: Maries [mailto:talk2mar...@gmail.com] > Sent: 02 May, 2011 5:13 PM > To: excel-macros@googlegroups.com > Cc: Prashant > Subject: Re: $$Excel-Macros$$ Help in Access > > Hi Prashant, > > Find the attachment... I hope that it will bring unmatch as per your new > tables... > > Code: > SELECT Lanpos.Match > FROM Lanpos LEFT JOIN Bank ON Lanpos.[Match] = Bank.[Match] WHERE > (((Bank.Match) Is Null)) UNION SELECT Bank.Match FROM Bank LEFT JOIN Lanpos > ON Bank.[Match] = Lanpos.[Match] WHERE (((Lanpos.Match) Is Null)); > > Regards, > > Maries. > > On Mon, May 2, 2011 at 10:51 AM, Prashant <pawleprash...@gmail.com> wrote: > > > Dear Maries, > > Sorry for delayed reply, many thanks for below code, it worked fine > for that > table. But I tried to use that union function in my actual data > sheet, coz > of my limited knowledge not able to get desired results. > > Attaching herewith two data tables namly bank & lanpos , only > "match" is the > common filed. > > I want unmatched data as a my query results from both data tables > > Thanks once again > > Regards, > > Prashant > > > -----Original Message----- > From: Maries [mailto:talk2mar...@gmail.com] > Sent: 30 April, 2011 10:26 PM > To: excel-macros@googlegroups.com > Cc: pawleprash...@gmail.com > Subject: Re: $$Excel-Macros$$ Help in Access > > Hi Prashant, > > Find the attached file.. I hope this will fulfill your > requirement... We can > arrive it with help of union query by using following SQL codes. > > SELECT Bank.card, Bank.aut, Bank.amt > FROM Bank LEFT JOIN lanpos ON Bank.[card] = lanpos.[card] WHERE > (((lanpos.card) Is Null)) UNION SELECT lanpos.card, lanpos.aut, > lanpos.amt > FROM lanpos LEFT JOIN Bank ON lanpos.[card] = Bank.[card] WHERE > (((Bank.card) Is Null)); > > > Regards, > > Maries. > > On Sat, Apr 30, 2011 at 4:54 PM, Prashant <pawleprash...@gmail.com> > wrote: > > > Dear All, > > > > I am trying to create unmatch data query thru access. I have > two > tables namly bank & lanpos, my qry is throwing only unmatched data > from > lanpos table, where as I want unmatched data of both tables as my > result > > > > Please help. > > > > > > Regards, > > > > Prashant > > > > -- > > > > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at > http://exceldailytip.blogspot.com > > To post to this group, send email to > excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > > > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
