Naughty Access query

[Mr Robin]

I know this is an Excel board and I'm sorry but I hoping that someone can still help.
Any ideas how I can right a query that will just select all values in a table apart from the lowest and highest 5% of values for a certain field.
For example, suppose the table contained salary details, how could I ignore the lowest paid 5% and the highest paid 5%.

Thanks in advance.

 

[Joe4]

This is an Access page on this site. Try posting it there:
http://www.mrexcel.com/board2/viewforum.php?f=14

 

[Mudface]

I did this using three queries, although you could probably do it in one with a subquery. The table I created had two fields-

Name (Primary Key)
Salary

The first query I saved as Bottom95, the SQL was-

SELECT TOP 95 PERCENT Table3.Salary, Table3.Name
FROM Table3
ORDER BY Table3.Salary;

The second was called Top95, the SQL was -

SELECT TOP 95 PERCENT Table3.Salary, Table3.Name
FROM Table3
ORDER BY Table3.Salary DESC;

Finally, I added both queries to a new query and used this SQL-

SELECT Bottom95.Salary
FROM Bottom95 INNER JOIN Top95 ON Bottom95.Name = Top95.Name;

BTW, there is an Access forum on the board, this will probably be moved there.