decimal places issue

[Chimp8471]

Hi, i am sure this has been addressed hundreds of times, but i have had a look around and cant seem to get to the answer i am looking for:

Problem:

I have a query that calculates total time dived by the number of occurances.

the trouble i am having is that when there are a recurring decimal places i get the following:

TimePerEvent

11.6666666666667
10.6666666666667

what i am after is 11.66 and 10.66 etc,

i have changed the decimal place to 2 but this makes no difference.

my table values are set to Double

any ideas

Andy

 

[Mile-O]

Set the format to 0.00

 

[Chimp8471]

milo, it must hurt to be that dam good...

cheers