calculate a formula and store.

[Thomas L.]

I have 3 fields: Rent, Tender, and Change Due

I have my db setup to store rent and tender in their respective places in a
table.
I have Change Due setup to perform =Tender-Rent.

How can I store this value in my table?

Thanks

Thomas

 

[Steve Schapel]

Thomas,

The correct place for the Change Due field is in a Query. This field
should not be in a table. Just delete it from the table, and any time
you need to use this value for your purposes on form or report, just
retrieve it from the query, where it will be entered as a calculated
field like this...
Change Due: [Tender]-[Rent]

- Steve Schapel, Microsoft Access MVP