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.

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.

Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.