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.

There's no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert ...

For example, in the above scenario, you could limit the query output to records whose total price is greater than 500 by adding >500 to the Criteria row under the calculated field.

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.

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.