I have a database that holds scores for shooters. I am trying to get a report that breaks down certain shooters who score above a certain amount. I am taking the shooters who score above a certain amount in each class and using a select top 1 query, pulling out the top shooter and awarding them 10 points. No problem. The issue comes in when I take the remainder of those shooters who shot above a certain score. I then need to take the top 15% of the remaining shooters and award them 7 points. Problem is, if I use Select Top 15 percent in the sql statement of the access query, if the total number of shooters is less than .5 (ex 3 shooters remain. 3 x .15 is .45), access is pulling in one shooter. It seems to be rounding up if there is anything in the record rather than less than .5 rounding down to 0, which is what I need it to do. If the amount remaining is less than .5 I need it to drop the record and award no one. But it is pulling in one record.
What am I missing here? Why is access not rounding down less than .5 to 0?
Thanks.
John