I have a simple query where in I am looking at Member Plans in 6 different states. I need to group by State and get a count of total plans per state and then have a grand total at the end can I do this in Access? I am using MS Access 2007 odbc connected to an Oracle Database. I am enclosing a copy of the query design. Thanks!!