S
S
I have created a query that adds two fields together and divides it by two.
I used the round function, but it doesn't round up, it just drops the decimal.
Average: Round(([Total Performance]+[Total Technique])/2)
How do I get it to round up?
IE if 1 field has the number 279 and the other field had the number 274
It should add them up divide by two = 276.5
I want it to return 277, but instead i get 276.
please help
I used the round function, but it doesn't round up, it just drops the decimal.
Average: Round(([Total Performance]+[Total Technique])/2)
How do I get it to round up?
IE if 1 field has the number 279 and the other field had the number 274
It should add them up divide by two = 276.5
I want it to return 277, but instead i get 276.
please help