How to Run the Query Wizard in Access 2013
If the wizard asks you to choose between a Detail and a Summary query, click the radio button next to your choice and then click Next.
Detail creates a datasheet that lists all records that match the query. As the name implies, you get all the details from those records.
Summary tells the wizard that you aren’t interested in seeing every single record; you want to see a summary of the information instead.
f you want to make any special adjustments to the summary, click Summary Options to display the Summary Options dialog box. Select your summary options from the check boxes for the available functions — Sum, Avg, Min, and Max — and then click OK.