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,
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,
can you share your access database?
On Thu, Sep 19, 2013 at 10:40 PM, Michael Pablo skypablo...@gmail.comwrote:
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
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,
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,
Make a query as Select Top 20 From your table name 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 your table name order by
your sort column
In case you