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.

Creating a calculated field in a query is pretty straightforward: Create a new query in Design view. Add at least the Quantity and Unit Price fields.

In Microsoft Access, fields can be added and removed from the list of available fields. Learn how to add or delete a Field in Design View 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. The field is ...