• To change the number of decimal places displayed, make sure that you change the format to fixed, as well as specifying the number of decimal places.
• The number of decimal places can also be changed by using the Round function i.e. Round(10.55555,2 ) will round to 10.56.

 The following function, Iif is very hand, it lets you decide between two options and display the desired option.  The first paramater specifies the field to compare, the second specifies the value to display if the first parameter is correct, the third specifies the value to display if the first paramater is false.

IIf( Count(*)=1 , "detail record" , "detail records" )