Question ID: 2222 27/29
PREVIOUS QUESTION NEXT QUESTION

Create a new totals query named sumorders based on the r_orders query that will display only the Surname, FirstName, sum1 (the sum in the TotalValue field) and max1 (the maximum value in the TotalValue field) fields. Also apply sorting by sum1 in descending order.

 

 

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

 

 

 


Create a new totals query named sumorders based on the r_orders query that will display only the Surname, FirstName, sum1 (the sum in the TotalValue field) and max1 (the maximum value in the TotalValue field) fields. Also apply sorting by sum1 in descending order.