Vertaling van "domain aggregate function" in Japans
We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
定義域集計関数
Expressions that match rows based on the result of a domain aggregate function
定義域集計関数の結果に基づいて行を抽出する式
You use a type of function called a domain aggregate function when you need to sum or count values selectively.
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.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.