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
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
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
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,
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.
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
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