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.

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. The field is ...

Why do you want to store that field?<BR><BR>There's probably an easier and/or more elegant solution to the big-picture problem you are trying to solve that doesn't involve a hack.