Recalcualte an Expression in Query

[DD]

I have made a form from a query that calculates [Enter Amount} +
[MarkUp]-[Discount]=Total
I want to add a field Named [AdjustTotal] this field then recalculates
the MarkUp and Discount Fields and Total, I can do some code in the
report which hides or displays either, however i want to show the
calculation change in the form
Any thoughts
Regards
DD

[Larry Linson]

I can think of a couple of ways to handle this.

(1) Do your calculation in the Query or

(2) Do the calculation in VBA code, using the values calculated in the
query, modified in the code, and display in an unbound Text Box. If you use
the TextBox bound to the values calculated in the Query and don't want it
seen, set its Visible property to No.

Access Reports do not allow you to override a bound Text Box from VBA code.

Larry Linson
Microsoft Access MVP
"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...

I have made a form from a query that calculates [Enter Amount} +
[MarkUp]-[Discount]=Total
I want to add a field Named [AdjustTotal] this field then recalculates
the MarkUp and Discount Fields and Total, I can do some code in the
report which hides or displays either, however i want to show the
calculation change in the form
Any thoughts
Regards
DD