November 25, 200124 yr Is there a way to round a summary field that is an average? (besides making the field too small to show the decimals?!) Paul
November 25, 200124 yr 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
Create an account or sign in to comment