Editing Content :: Admin Scraper

Chapter

Content type

Position

Value

APPENDIX Description of Commonly Used Functions in Access There are three types of functions that are used to set the Control Source property of calculated controls and/or to form part of calculated field expression in SQL statement. A brief description of the commonly used functions is below : A-1. Domain Aggregate Functions These functions are used to perform calculations based on values in a field of a table or query. Criteria to select the set of records in the table or query that is desired to be used for calculations may also be specified. The criteria, if not specified, imply that all the records of the table or query specific to the field are used for computation. All the domain aggregate functions use the same syntax as is given hereunder : DFunction (“FldName”, “TblName” or “QryName”, “SrchCond”) Wherein DFunction refers to a named domain aggregate function. A brief description of its input arguments is given below: FldName : It refers to the name of field that is to be searched in a table or query, which is specified as an argument. TblName (or QueryName) : It refers to the name of a table or query that contains the field specified as second input argument. SrchCond : It refers to the search condition on the basis of which the relevant record is searched. Some of the important domain aggregate functions have been described as below : (a) DLookup : This function is meant to look up information that is stored in a table or query, which is not the underlying source of Access Form or Report. It is used to set the Control Source property of a calculated control to display data from other table or query. Consider the following example: DLookup (“Name”, “Accounts”, “Code = ‘110001’”) In the above example, this function has been applied to search the name of account (in Accounts table) whose code is ‘110001’. (b) DMax and DMin : These functions are used to retrieve respectively the maximum and minimum values in the specified field. Consider the following example : DMin (“Amount”, “Vouchers”, “Debit = ‘711001’”) Dmax (“Amount”, “Vouchers”, “Debit = ‘711001’”) In the above examples, the amount of minimum purchase transaction and maximum purchase transaction is retrieved and reported. It may also be noted that ‘711001’ is the code of Purchase account in Accounts table (c) DSum : This function computes and returns the sum of the values in the specified field or expression. For Example, in a table : Sales that contains Reprint 2026-27