Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-23 Thread Michael Pablo
Sorry for my Fault, I translate PAIS in portuguese to country and this can mess your thoughts but nevertheless you were precise! I adapt just the name and works beutifully! I am thankful for your help. Follow the answer. SELECT TOP 20 MIDASQ12013.PAIS AS Expr1, MIDASQ12013.ATC3_COD, Sum(MIDA

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-20 Thread Anoop K Sharma
Use below one there is no field named as country.. if it doesn't work then let me knw. SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-19 Thread Anoop K Sharma
can you share your access database? On Thu, Sep 19, 2013 at 10:40 PM, Michael Pablo wrote: > Hi Enrique, > > I've attempted this Query but I didn't get results. They return this > advertence, saying that I need to use the clausule EXISTS. > > SELECT TOP 1 * FROM MIDASQ12013 > WHERE MIDASQ12013.P

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-19 Thread Michael Pablo
Hi Enrique, I've attempted this Query but I didn't get results. They return this advertence, saying that I need to use the clausule EXISTS. SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.PAIS EXISTS (SELECT TOP 20 MIDASQ12013.PAIS, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08,

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-18 Thread Anoop K Sharma
I hope the below one works good to you... pls check SELECT TOP 1 * FROM MIDASQ12013 WHERE MIDASQ12013.COUNTRY IN (SELECT TOP 20 MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-18 Thread Michael Pablo
Hello Enrique Martin, I have been attempted this query: SELECT MIDASQ12013.COUNTRY, MIDASQ12013.ATC3_COD, Sum(MIDASQ12013.EUR_2008) AS KEUR08, Sum(MIDASQ12013.EUR_2009) AS KEUR09, Sum(MIDASQ12013.EUR_2010) AS KEUR10, Sum(MIDASQ12013.EUR_2011) AS KEUR11, Sum(MIDASQ12013.EUR_2012) AS KEUR12, S

Re: $$Excel-Macros$$ RecordSet ADO get the 20th record

2013-09-16 Thread Anoop K Sharma
Make a query as "Select Top 20 From " in case you need a 20th record without changing your records order. but if you want the 20th record after sorting your data in ascending order then make following query "Select Top 20 From order by " In case you need the 20th record after sorting data in des