Page 286 - IT 402 v2.0 class 10
P. 286
Step 6: ouble-click on the uery name to run the uery. Notice that a new column titled Amount Payable
is displayed showing the necessary calculations. emember that calculation can be made only on
those fields where data type used is Numeric.
Grouping Data in Queries
In business organisations and companies, the senior management needs reports in summary form. In such
situations a summary report can be prepared grouping records on the basis of field that contains repetitive
values.
For example, consider the stock table of a departmental store which sells items that include Kitchen
Appliances, Furniture and Decoration. The senior management wants to know the quantity of stock under
each category of products.
Observe in the given table that some of the entries in the Product_Category field are repeating. ase allows
the user to categorise the data on this field. his field on the basis of which data is being grouped is called
group-field.
ase creates ueries for grouping data on the basis of:
roup-field
Grouping function
Grouping function refers to the in-built function used to present grouped data. The grouped data can be
presented in the form of S M M IM M MINIM M O N etc. of the values stored in the table.
To create a grouping query, follow these steps;
Step 1: Create a new query in the Design view.
Step 2: In the Field row in the Query Design pane in the first column select and use the group-field which
in this case is Product_Category.
2
284 Touchpad Information Technology-X

