Examples of using Calculated control in English and their translations into Malay
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
Create a calculated control.
Calculated control This is a control whose source of data is an expression rather than a field.
The expressions in the following table show some ways to use calculated controls on reports.
You can use these expressions in calculated controls on forms reports, or in query criteria rows.
So a“Control” whose data source is an expression andnot a field is a calculated“Control”.
You could use the DLookup function in a calculated control to display the ProductName on the same form.
A text box can be a bound control, an unbound control, or a calculated control.
Or, you can use the DSum function in a calculated control to display a running sum of sales for a particular product.
When you use an expression as the data source for a control, you create a calculated control.
When you place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group.
Use the DMin and DMax functions in a Visual Basic for Applications(VBA) module, a macro,a query expression, or a calculated control.
Calculated control A control whose source of data is an expression, rather than a field, is called a calculated control.
If you use the DStDev or DStDevP function in a calculated control, include a data type conversion function in the expression to improve performance.
Use the DLookup function in a Visual Basic for Applications(VBA) module, a macro,a query expression, or a calculated control on a form or report.
When you place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group.
You can then bind forms and reports to those tables or queries,and the calculations appear on the forms or reports without needing to create a calculated control.
To create a calculated control, you enter an expression in the ControlSource property of the control, instead of in a table field or query.
Whether you use the DStDev or DStDevP function in a macro, module,query expression, or calculated control, you must construct the criteria argument carefully to ensure that it will be evaluated correctly.
When you place a calculated control that uses the Sum aggregate function in the report header, the sum calculated is for the entire report.
The expressions in the following table use the&(ampersand) and the+(plus) operators to combine text strings, built-in functions to manipulate a text string,or otherwise operate on text to create a calculated control.
Use the DMin or DMax function in a calculated control when you need to specify criteria to restrict the range of data on which the function is performed.
For example, you could use the DMax function in calculated controls on a report to display largest order amount for a particular customer.
When you create a form that uses bound, unbound, and calculated controls, it is probably most efficient to add and arrange all the bound controls first, especially if they make up the majority of the controls on the form.
For example, you could use the DMin and DMax functions in calculated controls on a report to display the smallest and largest order amounts for a particular customer.
You can also use the DLookup function in an expression in a calculated control on a form or report if the field that you need to display isn't in the record source on which your form or report is based.