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
   289   290   291   292   293   294   295   296   297   298   299