Re: $$Excel-Macros$$ Help in Access
Dear Manoj, Please use it.. SELECT Month, Store ID FROM [Acer All Data] WHERE ((Month)="apr'12")); -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 29, 2012 at 7:11 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Manoj, > > Try this > > select [store id] from [Acer All Data] group by [store id] > select [store id] from [Apr'12] group by [store id] > select [store id] from [Mar'12] group by [store id] > select [store id] from [May'12] group by [store id] > > Regards, > Lalit Mohan > > > On Fri, Jun 29, 2012 at 3:14 PM, Manoj Kumar > wrote: > > Dear Experts, > > > > > > I have data in month wise data in Access in different query.. > > Please help me to find unique id From DATA in attached file.. > > > > > > > > Regard > > Manoj > > > > -- > > FORUM RULES (986+ members already BANNED for violation) > > > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will > > not get quick attention or may not be answered. > > > > 2) Don't post a question in the thread of another member. > > > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > > > 4) Acknowledge the responses you receive, good or bad. > > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > > owners and members are not responsible for any loss. > > > > > -- > > To post to this group, send email to excel-macros@googlegroups.com > > > > To unsubscribe, send a blank email to > > excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Help in Access
Hi Manoj, Try this select [store id] from [Acer All Data] group by [store id] select [store id] from [Apr'12] group by [store id] select [store id] from [Mar'12] group by [store id] select [store id] from [May'12] group by [store id] Regards, Lalit Mohan On Fri, Jun 29, 2012 at 3:14 PM, Manoj Kumar wrote: > Dear Experts, > > > I have data in month wise data in Access in different query.. > Please help me to find unique id From DATA in attached file.. > > > > Regard > Manoj > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Help in Access
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 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 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 > 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
RE: $$Excel-Macros$$ Help in Access
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 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 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
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 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
Re: $$Excel-Macros$$ Help In access
Dear Vikas Please find required info on below mention link http://www.techonthenet.com/top10/access.php On Sun, Mar 28, 2010 at 2:35 PM, Vikas Chouhan wrote: > > Dear All, >> >> >> Please help me in *access* please provide access queries and how to put >> queries,,, >> >> *and how to vlookup,concatenate in access * >> >> >> -- >> One Team One Dream One Goal >> >> Warm Regards, >> Vikas Chauhan >> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, >> 9911868518, >> "We can't Spell S_ccess without U" >> >> Life is Very beautiful !!! >> ¨`•.•´¨) Always >> `•.¸(¨`•.•´¨) Keep >> (¨`•.•´¨)¸.•´ Smiling! >> `•.¸.•´. >> > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > > To unsubscribe from this group, send email to excel-macros+ > unsubscribegooglegroups.com or reply to this email with the words "REMOVE > ME" as the subject. > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.