Results 1 to 2 of 2
  1. #1
    ehtupetey is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    2

    Cross Tab Query not Grouping By

    The cross tab query I've constructed is not Grouping all of the row elements together (see below)


    Click image for larger version. 

Name:	accessprob.PNG 
Views:	6 
Size:	2.5 KB 
ID:	17350

    This is a fairly simple cross tab query (As Far as I'm aware). There are no joins involved, only a few function calls within the query to process data.

    Suggestions; help?
    Attached Thumbnails Attached Thumbnails accessprob.PNG  

  2. #2
    ehtupetey is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    2

    Never mind

    Problem solved- Had extra "Group By"s in query

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

Similar Threads

  1. How do I use a MODULE in a Cross-Tab Query?
    By timo1999 in forum Modules
    Replies: 2
    Last Post: 12-13-2014, 04:51 PM
  2. Cross Tab Query.
    By cap.zadi in forum Queries
    Replies: 1
    Last Post: 01-04-2012, 01:29 PM
  3. Cross-tab query YTD
    By stremchem in forum Queries
    Replies: 9
    Last Post: 08-26-2010, 10:09 AM
  4. Cross Tab Query
    By RycherX in forum Queries
    Replies: 1
    Last Post: 04-26-2010, 12:19 PM
  5. Cross Tab Query
    By nengster in forum Queries
    Replies: 0
    Last Post: 02-18-2009, 07:12 PM

Tags for this Thread

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