I have a field with numbers in it. I specified in the table that the field holds up to 2 decimal places. I did the same in queries that contain that field and columns with calculations that utilize those numbers. However, I still see even up to four or five decimal places used in my query and table fields. How can I get my 2 decimal places to show?

Format the field to a fixed number.

Or use a rounding function

I tried the fixed format and it works in the query and the table but not in the report. What could be the report's problem? I am not sure how to use the rounding function. Still searching.

Problem Solved! I just needed to go to my report fields and specify 'fixed' there too. Thanks folks.