Results 1 to 3 of 3
  1. #1
    AnnLillandFinn is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    1

    Crosstab query question

    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.

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 10 Access 2013
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,538

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-16-2013, 01:36 AM
  2. CrossTab Query Question
    By djclntn in forum Queries
    Replies: 1
    Last Post: 11-29-2011, 11:33 AM
  3. Crosstab Query Question
    By hnguyen1987 in forum Access
    Replies: 1
    Last Post: 08-20-2010, 12:54 PM
  4. Replies: 1
    Last Post: 07-30-2010, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums