Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Calculation
|
|
|
The UK's most regular 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. |
microsoft+access+courses+in+london - Calculation
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
|