round up decimal to next whole number

[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

 

[KARL DEWEY]

Try this --
Average: Round(([Total Performance]+[Total Technique])/2,0)

 

[KARL DEWEY]

Last post not correct --
Average: IIf((([Total Performance]+[Total Technique])/2)-Int((([Total
Performance]+[Total Technique])/2))>0,Int((([Total Performance]+[Total
Technique])/2))+1,(([Total Performance]+[Total Technique])/2))

 

[S]

That did not work?

Any other suggestions?

Try this --
Average: Round(([Total Performance]+[Total Technique])/2,0)

--
KARL DEWEY
Build a little - Test a little

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

 

[S]

That worked. Thank You!

Last post not correct --
Average: IIf((([Total Performance]+[Total Technique])/2)-Int((([Total
Performance]+[Total Technique])/2))>0,Int((([Total Performance]+[Total
Technique])/2))+1,(([Total Performance]+[Total Technique])/2))

--
KARL DEWEY
Build a little - Test a little

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

 

[John Spencer]

Simpler formula if the number is always positive.

-Int(-(([Total Performance]+[Total Technique])/2))



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

That worked. Thank You!

Last post not correct --
Average: IIf((([Total Performance]+[Total Technique])/2)-Int((([Total
Performance]+[Total Technique])/2))>0,Int((([Total Performance]+[Total
Technique])/2))+1,(([Total Performance]+[Total Technique])/2))

--
KARL DEWEY
Build a little - Test a little

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