Results 1 to 2 of 2
  1. 05-15-2013, 09:21 AM #1
    kgmanager
    kgmanager is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2013
    Posts
    3

    Collapsing crosstab rows based on identical row heading

    Click image for larger version.  <br /><script async src=
    Name: example.jpg  Views: 5  Size: 26.5 KB  ID: 12361" class="thumbnail" style="float:CONFIG" />

    Please see the picture above. As you can see two models appear twice in the cross tab because they have two different entries. How can I have each model appear only on one row with both entries still shown. (Essentially collapse them together)

    Thanks for the help!
    Reply With Quote Reply With Quote
  2. 05-15-2013, 09:09 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Did you try doing a GROUP BY (Totals) query with the crosstab?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. formatting report detail based on group heading
    By sanmagoo in forum Reports
    Replies: 1
    Last Post: 04-05-2013, 01:58 PM
  2. Month Name in CrossTab Heading
    By stumped in forum Queries
    Replies: 2
    Last Post: 09-27-2012, 02:29 PM
  3. Report from a Crosstab query column heading problem....Very frustrating!!!
    By Frasier433 in forum Reports
    Replies: 4
    Last Post: 07-27-2012, 07:04 AM
  4. How to get more than one value/column heading in crosstab query
    By bhaktharvali in forum Queries
    Replies: 3
    Last Post: 02-21-2012, 10:15 AM
  5. Specifying Date Format for Column Heading in Crosstab Query
    By mwolfod in forum Queries
    Replies: 20
    Last Post: 02-14-2011, 10:55 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums