I have text box that displays a calculated value. the calculation is done in a query. My problem is the true value sometimes is one more than or one less than the calculated value (b/c of mis-counts). So, I would like to be able to override the calculated value and manually enter the true value.
I understand that calculated values are not saved on table (which is the way my database works too). this means when I query, I would have a problem b/c I can only get the calculated value. Anyone have thoughts or ideas on how I should approach this?