Average output

[Guest_imported]

How do I make my averages in my report with 2 positions after decimal point.

Now it shows: 7.3411666

I want: 7.34

 

[WildHare]

Change the DISPLAY FORMAT of the field to GENERAL NUMBER and the DECIMAL PLACES to 2.

Right click the box it's appearing in and select PROPERTIES, and the DATA tab...

There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[WildHare]

Sorry the FORMAT tab on the properties box...my memory is failing me... There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm