Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Calculations on a Form

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Calculations on a Form

Resolved · Low Priority · Version 2003

Reply Thu 2 Sep 2010, 11:12Delegate George said...

George has attended:
Excel VBA Intro Intermediate course

Calculations on a Form

Hello,

Actually I have to create an application in which the user has to post amounts in fields and then I need automatic calculations (ratios) on the Form and these calculations to be saved in the table.

I shall really appreciate it, if I could have your advise on this matter.

Thanks.

George

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Sep 2010, 15:35Trainer Nafeesa said...

RE: Calculations on a Form

Hi George

Thank you for your question.

Apologies in the delay in getting back to you. Your question has been referred to an Excel VBA trainer.

We will endeavour to get a response to your question by Monday.

Kind Regards,

Nafeesa

Microsoft Office Specialist Trainer

Access articles

· Access 2007 Is All About Systems
· Access Corruption Avoidance Tip #1: Split Your Database
· How To Create A Combo Control On An Access Form
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· How To Import Data Easily Into Access 2010

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips