Changing the values in a calculated field
Posted on 2011-02-22
I have a MS Access DB that uses several queries. Some of these queries have calculated fields of a currency value. One of these calculated fields is called 'Balance Owing' - I want to take all the entries for 2009, and give them a $0.00 balance, as they're all paid off now.
But, when I tried doing that (by using an update query and using the BETWEEN command to search the date range), I got a message that said you cannot change the values of calculated fields.