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
Access.rar
Description: application/rar
