Formulas

Resolved · Medium Priority · Version 2007

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

Jennifer has attended:
Access Intermediate course

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

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

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

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

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.

	98.8 % recommend us
	More live stats...

Training information:

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)