Step-By-Step: Calculate totals in Access on the fly Your email has been sent Instead of wasting disk space with stored values, you should use calculated fields whenever possible in a database ...

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.

You’ve created a query that calculates an invoice total by adding the order total and the shipping charges. You used this formula for the calculated field: Invoice_Total: [Shipping Charge ...

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data.