Thanks LB, that worked great. Now the only problem I see is sorting by the Hours. We'd like to be able to sort so the Cities with the highest hours are first so a descending list. I can't seem to do this in the Record Sort like I'm used to. I can't get Hours before the State, County, and...
I have five columns of data like this:
Col A: State
Col B: County
Col C: City
Col D: Month
Col E: Hours
If A, B, and C all match, I want to sum Col E. So it doesn't matter what D is. I probably won't even show D in the report. I just want one line instead of two or more.
Ex:
Virginia Fairfax...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.