![]() So now, you introduce a criteria in the DSUM() function by referencing directly to the field. You are somewhat expecting a similar output as follows: In order to do so, you’ll refer the table ‘Orders’ which holds all the related details of the shipped orders. Let’s consider a scenario where you want to determine the total shipping fee paid across all the cities to which you have shipped your products. This will get clearer as we go through more examples below. Remember : The text/number/date can either be specified directly or it can be specified by referencing it to a column containing the required text/number/date values. In the above snapshot, in place of = sign, you can also use other comparison operators like ,=.įurther, there are three types of criteria that can come after these comparison operators. In order to understand how the DSUM() function behaves when a criteria is specified, let us first analyse the criteria part of the DSUM() function. On running this query, you’ll get the following result: Lets say, you want to sum the field in the table ‘Order details’ to see the total units ordered. In order to understand how a DSUM() function behaves when no criteria is specified, let us have a quick look at the following example : Lets look at each of the two ways of working with DSUM() function. Construct a DSUM() function with a Criteria
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |