formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Formulas

Formulas

resolvedResolved · Medium Priority · Version 2007

replyReply Wed 21 Dec 2011, 16:44Delegate Jennifer said...

Jennifer has attended:
Access Intermediate course

Formulas

What is the fomrat or pattern to writing formula in access tables?

For upcoming training course dates see: Pricing & availability

replyReply Thu 22 Dec 2011, 09:46Trainer Anthony said...

RE: Formulas

Hi Jennifer, thanks for your query. The best way to do that would be a calculated field in a query. Have a look here:

http://599cd.com/tips/access/calculated-query-fields/

Hope this helps,

Anthony

replyReply Mon 9 Jan 2012, 10:08Delegate Jennifer said...

RE: Formulas

I was referring to the formula that can added to the expression builder. Do the components of these formulae have to be in a particular order?

Thu 29 Dec 2011: Automatically marked as resolved.

 

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

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard