Summary Field

[Wildy71]

Is there a way to round a summary field that is an average? (besides making the field too small to show the decimals?!)

Paul

[Steven H. Blackwell]

You can format the field to show only a given number of digits. In layout mode, select the field, and right click to give the various options. Choose number format.

Strictly speaking this is not rounding, but it will control the display. Otherwise you have to either capture the summary value and then treat it as a stored value (a transaction based process) and then round it or use the GetSummary Function in conjunction with the Round function.

HTH

Old Advance Man