Need help in Report footer

[wannabepro]

e.g. instead of $65000.00, I just want it to show $65000. I can do this inside the body of the report but not in footer body, any suggestions?

I don't want to see cents at the end of currency.

Actually, I forgot to mention that I am using a list box to show all the listing of currency, I know with the text box it is possible to do this.

 

[Ukraine82]

Open your table where currency field is located and change it to 0 instead of Auto in decimal places.

hth,
Michael

 

[wannabepro]

Use the control properties dialog to change the format of the control to show no decimals.

I have done that, I have not only change that in table but also in query properties, but still it shows cents.

thanx for ur help guys, I might be able to work out something.

 

[wannabepro]

Expr1: Round([SumOfAmountofCredit],0)

I can use this in query, but after this I lose comma and Currancy sign, is there a way to not elimnate thos two essential things.