show 1st 3 and last 3 records 2

[webware]

I am running the following Query and was wonder how to add to this in order that I can display the first 3 and last 3 records.

SELECT house.P1, Count(*) AS EXPR
FROM house
GROUP BY house.P1
HAVING (((Count(*)+1)<>False))
ORDER BY Count(*);

Thanks to anyone that can help

 

[cmmrfrds]

You could try 2 queries, not sure about doing in 1 query.

SELECT TOP 3 house.P1, Count(*) AS EXPR
FROM house
GROUP BY house.P1
HAVING (((Count(*)+1)<>False))
ORDER BY Count(*);

SELECT TOP 3 house.P1, Count(*) AS EXPR
FROM house
GROUP BY house.P1
HAVING (((Count(*)+1)<>False))
ORDER BY Count(*) DESC;

 

[webware]

thanks that worked!!!

 

[Craig0201]

And in 1 query....

SELECT TOP 3 house.P1, Count(*) AS EXPR
FROM house
GROUP BY house.P1
HAVING (((Count(*)+1)<>False))
ORDER BY Count(*);
UNION
SELECT TOP 3 house.P1, Count(*) AS EXPR
FROM house
GROUP BY house.P1
HAVING (((Count(*)+1)<>False))
ORDER BY Count(*) DESC;

Craig