An auo dealer's tblTrucks table has two text fields named Make and Model, and two numeric fields named Year and ListPrice. In the TableAdapter Configuration Wizard, which of the following statements adds the numbers in the ListPrice field to give a total value for the dealer's truck inventory?
A. SELECT SUM(ListPrice) AS TotalValue
B. SELECT AGGREGATE(ListPrice) FROM tblTrucks
C. SELECT SUM(ListPrice) AS TotalValue FROM tblTrucks
D. SELECT (@ListPrice) FROM tblTrucks
Answer: C
Computer Science & Information Technology
You might also like to view...
The Expression Builder does not have autocomplete capability for field names
Indicate whether the statement is true or false
Computer Science & Information Technology
Of the printer types listed, which printer type would be the best and the quickest to produce several color copies of a contract for potential clients?
A) 3-D B) Thermal C) Laser D) Impact
Computer Science & Information Technology