Crosstab query question

[AnnLillandFinn]

Hey guys. Let me preface everything I'm about to write with, I have next to no idea what I'm doing and very little experience and even less knowledge in Access.



But. I have quite a lot of data showing water meter reads by account, per month starting in January 2012.

I have a crosstab query for each year that displays the data beautifully for that year. Is there a way to display all months (so 50 months) consecutively in one query? Perhaps with another query?

Any help or ideas much appreciated.

[alansidman]

Perhaps something like this: http://www.datapigtechnologies.com/f.../crosstab.html

[orange]

cross posted and answered
http://www.utteraccess.com/forum/ind...c=2034992&st=0