Thu 24 Jan 2008, 17:02Delegate Elaine said...
Elaine has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Expression Builders
Is there a difference between using [] and ()?
Mon 28 Jan 2008, 12:35
Edited on Mon 28 Jan 2008, 12:35Trainer Carlos said...
RE: Expression Builders
Hi Elaine
In Access the [] square brackets are used to indicate to the system the names of fields or other objects in the database.
The () round brackets are used in the functions.
So to Add together all the Amount field values you write:
=Sum([Amount])
Hope this hepls.
Carlos
