SELECT TOP but Rounded Down...

B

Brian Cheresnowsky

I need to create a query that will return the top 10
percent rounded down. For example, I have 24 items, and
want to return the top 10 percent that are the highest
priced. 10 percent of 24 is 2.4, and when I run this in
the query, I get 3 items returned, but I only want to
show the 2 items since the decimal value did not
exceed .5.

Can anyone please advise?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up or down to nearest 5, but not 10 2
Top 3 per group 3
Selecting the top 1/3 of a table 3
query to get top player 8
Multiple Top Values 2
Select ONE record 1
Changing commission rate at a future date 5
Excel Round 3

Top