Fragen ID: 2541 17/29
PREVIOUS QUESTION NEXT QUESTION

Use the query wizard to create a crosstab query based on the SalesPerProduct query. The new query will display the ProductID and Description fields as row headings and the myYear field as column heading. Also make sure the query calculates the sum of the values displayed in the myTotal field. Save the query as NewSales and close it.

 

 

Other versions
Microsoft Access 2003Microsoft Access 2007Microsoft Access 2010Microsoft Access 2013Microsoft Access 2016Microsoft Access 365

 

 

 


Use the query wizard to create a crosstab query based on the SalesPerProduct query. The new query will display the ProductID and Description fields as row headings and the myYear field as column heading. Also make sure the query calculates the sum of the values displayed in the myTotal field. Save the query as NewSales and close it.