C
chris
It is not good practice to store "Calculated" fields in
tables, but it can be done if necessary.
Access is not like Excel. If you change a value in the
payments field, the value in the balance field will not
automatically update.
If you want a "view" that shows charges, payments and the
balance, use a query.
show 'Charges' - 'Payments'?
tables, but it can be done if necessary.
Access is not like Excel. If you change a value in the
payments field, the value in the balance field will not
automatically update.
If you want a "view" that shows charges, payments and the
balance, use a query.
a 'Payments' field. How do I ad a field 'Balance', to-----Original Message-----
In an Access table, I have a 'Charges' field &
show 'Charges' - 'Payments'?