|
|
|
|
|
- Overview
- How to?
- Adding an operation into the current Select query
- Deleting an operation from the current Select query
Operations in a Select query: Add and delete
The following paragraphs explain: - the addition of an operation into a Select query.
- the deletion of an operation from a Select query.
Adding an operation into the current Select query To add an operation into the current select query: - On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
- In the middle section, select the item on which an operation must be performed.
- To calculate:
- the sum of the values in the item, click on "Sum...".
- the average of the values in the item, click on "Average, Max, Min" and select "Average".
- the maximum value of the values in the item, click on "Average, Max, Min" and select "Maximum".
- the minimum value of the values in the item, click on "Average, Max, Min" and select "Minimum".
- An item corresponding to the requested calculation is automatically added to the query items.
- Validate. The operation is automatically added into the query.
Deleting an operation from the current Select query To delete an operation from the current Select query: - On the "Query" tab, in the "Edit" group, click "Description". The query description window appears.
- In the middle section, select the calculation item to delete.
- Press the Del key.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|