I Need help. I have a access database that is used for scheduling purposes. I have a form that allows you to select month and year and it will run a report based on a query showing what customers are do, how much there bill will be, etc.

What I want to do is use this query to create a report or pivot table to loop for each month in a year so I can quickly look at a year at a time, not just a month.

I can't seem to...