Report Rounds to nearest dollar, I need the cents.

[matchmole]

I have an Access report based on a query that calculates amounts and counts of checks issued. The query, when run, shows the amounts including the accurate cents. But the report rounds the amounts to the nearest dollar. All property fields are set to format:currency and decimal places:2. Any ideas where I'm going wrong? The report is kicked off by a macro which first runs the four queries, then opens the report in print mode, if that helps.

Thanks very much,
Match

 

[Gates Is Antichrist]

This can happen if you have Can Shrink and do NOT have Can Grow.

I recommend always, always, always using Can Grow, despite the insult of having to remember to do it every time you create a field or a new report itself. It should be set True by default but the Antichrist doesn't see it that way. (If CanGrow turns out to not be the solution, I still recommend at least considering it.)

That's all I can think of for your problem, if you're really sure decimal places are 2, and unless the data itself got rounded (while you weren't looking ).