The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total

Question:

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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: