Decimal Place property having no affect??

[105ben]

Hello,

I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2....

It lokks to be over riding it, how do I stop this?

 

[pr2-eugin]

Could you not use Round(theField, 2) in the query that you are calculating.. So you will get the right value in the field without setting the property?

 

[105ben]

How would I use that?

my expressions is already:

Expr1: Avg([time_resolved]-[time_occurred])

 

[pr2-eugin]

It should be

Expr1: Round(Avg([time_resolved]-[time_occurred]), 2)

 

[105ben]

Brilliant, thanks!