If you are building an Access form based on a query and notice you will need to add a calculated field, you don’t need to redesign your query — just add the calculated field to your form.

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.

You can perform all sorts of calculations in a query using calculated fields. You can even add criteria to calculated fields. For example, in the above scenario, you could limit the query output ...