Page 285 - IT 402 v2.0 class 10
P. 285
hen you run the preceding uery you will get the following output:
Performing Calculations in Queries
Many times the user needs to perform calculations on the fields used in a table. ase allows the user to create
a uery for performing such calculations. et us say in the table Month Sales the user needs to calculate
Total Amount as Quantity Unit_Price.
o create a uery for performing such calculations follow these steps:
Step 1: Create a query in the Design View. Insert all the re uired fields from the table into the uery.
Step 2: In the Field row in the Query Design pane in a blank column type uantity Unit_Price.
Step 3: Press the Enter key on the keyboard.
1
2
Step 4: In the Alias row enter a name for the field. For example here Total Amount can be typed.
4
Step 5: Save the uery by pressing Ctrl + S keys.
Database Management 283

