Show whole dollar amount only

[Russ via AccessMonster.com]

How can I get this to round up show dollar amount only, whole number no
decimal places?

Income: Format(Sum(CCur(Nz([DepositAmount],0))),"Currency")

Example

1.32 = 1
1.5 =2
1.6 = 2

Thanks in advance!

 

[Svetlana]

You can use round function.

 

[Van T. Dinh]

Try:

Income: Format(Sum(CCur(Nz([DepositAmount],0))),"$0")