You would most likely use a domain aggregate function in a macro or module, in a calculated control on a form or report, or in a criteria expression in a query.
You use a type of function called a domain aggregate function when you need to sum or count values selectively. A domain consists of one or more fields in one or more tables, or one or more controls on one or more forms or reports. For example, you can match the values in a table field with the values in a control on a form.
You use a domain aggregate function when you need to sum, count, or average values selectively. For example, you might want to count only those values that fall within a certain range, or that evaluate to Yes. At other times, you might need to look up a value from another table so that you can display it. The sample expressions in the following table use the domain aggregate functions to perform a calculation on a set of values, and use the result as the query criteria.
When you specify a criteria argument for a domain aggregate function, for example, Microsoft Access must evaluate any variables, concatenate them into a string, and then pass the entire string to the Access database engine.
You entered an invalid argument in a domain aggregate function. * A field in the string expression may not be in the domain. A field specified in the criteria expression may not be in the domain.@2@610931@1
You can use the string expression argument (the expr argument) in a domain aggregate function to perform a calculation on values in a field. For example, you can calculate a percentage (such as a surcharge or sales tax) by dividing a field value by a number.
You can specify numeric, textual, or date/time criteria. No matter what type of criteria you specify, the criteria argument is always converted to a string before being passed to the domain aggregate function. Therefore, you must make certain that after any expressions have been evaluated, all parts of the argument are concatenated into a single string, the whole of which is enclosed in double quotation marks ().
When you compute a total in Design view by using an aggregate function, such as Sum, or by using a domain aggregate function, such as DSum, you cannot use the name of a calculated control in the function.
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.