FWIW, the query in your last attachment is the totals query I mentioned in post 4. I think neither Allan nor I were visualizing the source data accurately; I suspect this website rearranged your sample data in post 5. Glad you found the solution.
Summary Query - How to?
Who is John Galt?
Windows XP 
Access 2007
FWIW, the query in your last attachment is the totals query I mentioned in post 4. I think neither Allan nor I were visualizing the source data accurately; I suspect this website rearranged your sample data in post 5. Glad you found the solution.
Administrator
Windows 7 Access 2007
That's great! Thanks for marking the thread as Solved.
Posting Permissions
Reply With Quote