Learn how to build tables with the Table Designer in Access. The process will help you analyze large amounts of information, and manage data efficiently.

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.

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 ...