Page 294 - Trackpad 402_Class-X_Final
P. 294
When you run the preceding query, 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. Base allows the user to create a query
for performing such calculations. Let us say, in the table Month_Sales, the user needs to calculate Total Amount as
Quantity * Unit_Price.
To create a query for performing such calculations, follow these steps:
Step 1: Create a query in the Design View. Insert all the required fields from the table into the query.
Step 2: In the Field row in the Query Design pane, in a blank column, type Quantity * Unit_Price.
Step 3: Press the Enter key on the keyboard.
Step 4: In the Alias row, enter a name for the field. For example, here, Total Amount can be typed.
294 Trackpad Information Technology-X

