Question: 5. The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total of the items in inventory? a. Dim
5. The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total of the items in inventory?
a. Dim intTotal As Integer =
Aggregate item In InventoryDataSet.tblInventory Select item.InStock Into Sum
b. Dim intTotal As Integer =
Sum item In InventoryDataSet.tblInventory Select item.InStock Into Total
c. Dim intTotal As Integer =
Aggregate InventoryDataSet.tblInventory.item Select item.InStock Into Sum
d. Dim intTotal As Integer =
Sum item In InventoryDataSet.tblInventory.InStock
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
