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
   280   281   282   283   284   285   286   287   288   289   290