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