Problems with decimals

[Jack Daniels]

Hi!
I have a table tblPrices with the format currency and two decimals.
I have a form based on the table
I have a querry based on the table qryPrices.
I have a report based on the guerry called rptPrices.

Now I don´t want the decimals and tries to get rid of them. I change the decimals in the table to 0. I change it in properties for the querry, the form and the report.

But they are still there. I don´t understand, pleas help me, Im desperat...;-)

 

[FLabrecque]

Have you tried format([field], "$0") in your queries?