decimal number

[Andrej]

Hello
my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals.
Column in the query and in the report is not reserved only for numbers.
if some one have idea?

 

[statsman]

If you only want to limit the decimal places in the report (that is you're not using the query for another function as well), on the report in design view right click the text box. Select properties, go to format. Set the format to:

0.00 (zero point zero zero).

This should limit the decimal places to two.