How do I Group and Summarize records in a Query, using the Criteria field, in Access 2007? If you want to group and summarize, or add up fields that are addable or contain numbers then you'll either use the Group feature in the Query, or it's Criteria field in a formula format. For example, say you have the details of an order like the "Quantity", and you'd like to times the by the "Price" to get the summary of all products within your query. You'd write the formula to have the two fields multiplied by each other, but within the order of operation i.e. using parenthesis around you formula and then outside of that formula or parentheses add the "Sum" to it. This will give you your totals for all in your Query!

Purchase the training video and you can see this in action for yourself!