Results 1 to 4 of 4
  1. #1
    kattatonic1 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Location
    Toronto, Canada
    Posts
    77

    Question Combine Crosstab query with Table to export together to Excel

    I have the following:

    1) Crosstab query grouped by Branch
    2) Table whose first column is Branch

    I can't seem to combine them. I want to combine them for export to Excel together. Users use the data together. I can of course have them export them separately and then combine in excel but it seems it should be easy enough to export them together given the Branch columns match.

    Any help would be apprecited.

    Kay in Toronto


    All thunderstormy today

  2. #2
    kattatonic1 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Location
    Toronto, Canada
    Posts
    77
    Or... could they at least end up in the same workbook on different worksheets perhaps?

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,674
    Why can't you join crosstab to table? - works for me - and exports to Excel perfectly.
    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.

  4. #4
    kattatonic1 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2013
    Location
    Toronto, Canada
    Posts
    77
    June7, sorry to waste your time. Can we say Brain Fart here? I just tried it again after your comment, and it's just dandy. Duh. Time for a weekend. Embarrassing. Many thanks for prodding me.

    Kay

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

Similar Threads

  1. Replies: 2
    Last Post: 03-28-2014, 11:25 AM
  2. Crosstab Query Values Export as Text
    By Paul H in forum Queries
    Replies: 0
    Last Post: 01-07-2013, 11:18 AM
  3. Replies: 1
    Last Post: 12-18-2011, 01:28 AM
  4. Replies: 5
    Last Post: 08-29-2011, 09:37 AM
  5. Replies: 1
    Last Post: 05-28-2009, 05:08 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
  •  
Tech Forums: Microsoft Office Forums