Var Returns the variance of the field values. This is a statistical function and there must be three or more values to calculate the variance. First Returns the value in the first record of a table or query. Last Returns the last value. Where Allows criteria to be established for queriesperforming calculations.
Some functions work with specific data types.
For example, you can use Sum with number and currency fields but not with OLE object or memo fields. To tell Access to carry out one of these functions on the data in a table, you open a Query window, click the Totals button on the toolbar to add a new Total row to the QBE grid, and then indicate the function you want to use in the appropriate column. Access puts the result in a new field in the query datasheet. Count, Avg, and Sum. Close any open Select Query windows without saving the queries, and open a new query for the Invoices and Clients table.