I am the President of Computer Learning Zone, a small education company dedicated to helping people learn how to use their computer, especially MS Access.
A long list of orders can hide the pattern you’re looking for. A crosstab query puts states down the side, months across the top, and the sum of sales at each intersection. Watch my Crosstab Queries video to see how to build it with the Query Wizard.
Press enter or click to view image in full size
Get Richard Rost’s stories in your inbox
Join Medium for free to get updates from this writer.
For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/2366.
I am the President of Computer Learning Zone, a small education company dedicated to helping people learn how to use their computer, especially MS Access.
