Results 1 to 3 of 3
  1. #1
    lukewarmbeer is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    5

    Crosstab Query


    I have created a crosstab query in Access 2007 and would like all the row headings to show regardless of whether there is a value. Is there a way to do this?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    not sure what you mean. row headings? you mean column headings? or do you want records to show that don't satisfy the query results?

  3. #3
    lukewarmbeer is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    5

    Crosstab Query

    In any query, is there a way to get all the data from a field. I want all the data for the field in the row heading even if there is no value under the column headings. My row headings are a list of times. If there is nothing scheduled under a time, I still want the time to appear.
    Also, is it impossible to prepare a report from a crosstab query.

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

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  3. Query - Crosstab ?
    By rob4465 in forum Access
    Replies: 1
    Last Post: 01-28-2010, 08:41 AM
  4. crosstab query calculation
    By rutica in forum Queries
    Replies: 2
    Last Post: 04-28-2009, 09:52 AM
  5. Criteria in Crosstab Query
    By wasim_sono in forum Queries
    Replies: 1
    Last Post: 12-12-2006, 05:14 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