Here's my problem,
I am using VBA code in Access2000. In my code it says to bring me back the first 10% of all the rows in a table. Which works good if I have a number like 500 rows which 10% is 50 and I get 50 rows returned. The problem is when I have 221 rows which 10% is 22.1 which is not a whole number. What I want to do is round all numbers up to the next whole number regardless if they are 2.1 to 2.9. All attempts so far have rounded for example 2.1 down to 2 and 2.5 up tp 3, what I want is both to be rounded to 3. Can anyone help?
I am using VBA code in Access2000. In my code it says to bring me back the first 10% of all the rows in a table. Which works good if I have a number like 500 rows which 10% is 50 and I get 50 rows returned. The problem is when I have 221 rows which 10% is 22.1 which is not a whole number. What I want to do is round all numbers up to the next whole number regardless if they are 2.1 to 2.9. All attempts so far have rounded for example 2.1 down to 2 and 2.5 up tp 3, what I want is both to be rounded to 3. Can anyone help?