microsoft access training courses - Expression Builder

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