How come I can't obtain accurate decimal places for percentages within Access. Below are some examples and I can't seem to understand the concept.
1. I generate these two and it gives me a whole number versus a decimal.
SELECT 120/1953 AS percentage;
SELECT 6/1953 AS percentage;
2. Then i generate these two and it gives the proper format
SELECT 84/1953 AS percentage;
SELECT 1743/1953 AS percentage;
I see the first two has an E-02 & E-03 at the end. I have union query that calculates these 4 percentages from query fields and since they are all accurately written, i am not sure why the discrepancy. I didn't post the code since i recreated it just using a basic division on what the sum numbers are in the queries.