I have created a report in an adp based on a query of a settlements table i have in my database. The field i am having trouble with is a calculated fields sum dropping cents. The field is Negotiators ...

In an Access report that contains numbers, you can use totals, averages, percentages, or running sums to make the data more understandable. This tutorial describes how to add totals to your reports.