Prev: USING PARAMETERS IN A CROSSTAB QUERY
Next: Filtered Form Query
From: KenSheridan via AccessMonster.com on 29 Jan 2010 19:29
I'd got into a MIN/MAX mindset! On second thoughts, even simpler:

SELECT T1.Country, T1.GDP
FROM TData As T1, TData As T2
WHERE T2.Country IN('Nigeria', 'Kenya')
GROUP BY T1.Country, T1.GDP
HAVING MAX(T2.GDP) > T1.GDP
AND MIN(T2.GDP) < T1.GDP;

Ken Sheridan
Stafford, England

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: USING PARAMETERS IN A CROSSTAB QUERY
Next: Filtered Form Query