Question: The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records having at least 500 of the item in

The tblInventory table contains a numeric field named InStock. Which of the following statements selects all records having at least 500 of the item in stock?

a. Dim records =

From item In InventoryDataSet.tblInventory

Where item >= 500

Select item.InStock

b. Dim records =

From item In InventoryDataSet.tblInventory

Select item.InStock >= 500

c. Dim records =

From item In InventoryDataSet.tblInventory

Where item.InStock >= 500

Select item

d. Dim records =

Select item.InStock >= 500

From tblInventory

Step by Step Solution

3.40 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c Dim records From ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming with Microsoft Visual Basic 2015 Questions!