5 The tblCities table contains a numeric field named Population Which of the following statements calculates the total population of all of the cities in the table a Dim intTotal As Integer Aggregate city In CitiesDataSet tblCities Select city Population Into Sum() b Dim intTotal As Integer Sum city In CitiesDataSet tblCities Select city Population Into Total() c Dim intTotal As Integer Aggregate CitiesDataSet tblCities city Select city Population Into Sum() d Dim intTotal As Integer Sum city In CitiesDataSet tblCities Population

Question

5  The tblCities table contains a numeric field named Population  Which of the following statements calculates the total population of all of the cities in the table  a  Dim intTotal As Integer   Aggregate city In CitiesDataSet tblCities Select city Population Into Sum() b  Dim intTotal As Integer   Sum city In CitiesDataSet tblCities Select city Population Into Total() c  Dim intTotal As Integer   Aggregate CitiesDataSet tblCities city Select city Population Into Sum() d  Dim intTotal As Integer   Sum city In CitiesDataSet tblCities Population

SolutionInn · Accepted Answer

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

Question: 5. The tblCities table contains a numeric field named Population. Which of the following statements calculates the total population of all of the cities in

Step by Step Solution