I have been working with Access a lot lately. In my last project I was working with a table that contained 1.4 million records with count values by US States. I needed run a graph based on the sum of values for each state. My original table looked like this: Table: States State Value MN 54 MN 62 IL 76 MN 34 CA 48 MN 62 IL 4 And so on... All of the way … [Read more...] about SQL QUERY | Sum Values by Group in Access 2010