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.

Did you know that you could calculate fields in the query in Microsoft Access? In this tutorial we will explain how to create Calculated Fields in Access.

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.