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.

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.