4 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

Question

4  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

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

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

Step by Step Solution