98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Calculation
microsoft+access+courses+in+london - Calculation
Resolved · Low Priority · Version Standard
Wed 7 Feb 2007, 09:35Delegate David said...
David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Calculation
Can I create calculation fields on forms?
Wed 7 Feb 2007, 11:09Trainer Richard said...
RE: Calculation
Yes you can.
There are 2 ways.
Option1
place a field that already has a calculation in it (ie. a query field) on the form. The field will recalculate each time you change the appropriate fields and record.
Option 2.
Simply type the formula that you want into the CONTROL SOURCE property for the field. an example is
=[Field1] * [Field2] / 1600
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |
