By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,262 Members | 2,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,262 IT Pros & Developers. It's quick & easy.

Recalcualte an Expression in Query

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.