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.

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.