I have a table in which I list each employee and their salary. I create a query with two calculated fields - one to calculate biweekly salary ([Annual Salary]/26) and one that calculates hourly salary ([Annual Salary]/2080). The results of each field, especially the hourly field, is calculating to 12 decimal places. You can't format these cell results as you would an Access Table field - help! I need only two decimal places!
No comments:
Post a Comment