Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft+access+courses+in+london - calculation

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Calculation

microsoft+access+courses+in+london - Calculation

ResolvedVersion Standard

David has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Calculation

Can I create calculation fields on forms?

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


Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.