Results 1 to 2 of 2
  1. #1
    EffBee is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2018
    Posts
    3

    Report structure - Where the matching records are on each row.

    Hello,

    This might be an obvious one but am stuck.



    I have 2 tables and a junction table. Table 1 is Countries, Table 2 is Activities.

    Table 1
    CountryName CountryID
    United Kingdom UK_001
    Ireland IR_001
    Denmark DM_001
    France FR_001

    Table 2
    Activity ActivityID
    Football FB_001
    Golf GF_001
    Tennis TN_001


    Junction Table:
    CountryID ActivityID
    IR_001 GF_001
    IR_001 TN_001
    UK_001 FB_001
    UK_001 TN_001
    DM_001 FB_001
    DM_001 TN_001
    FR_001 GF_001
    FR_001 FB_001
    FR_001 TN_001

    How can I produce a report that looks like this, with the matching activities on each row so I can compare? Or can I have a nudge in the right direction?

    United Kingdom Ireland Denmark France
    GF_001 GF_001
    FB_001 FB_001 FB_001
    TN_001 TN_001 TN_001 TN_001

    Thank you,

    EffBee

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Use the query wizard and make a Crosstab query.
    you need a field to show as the row,
    country as the column header,
    Use FIRST as the data value.

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

Similar Threads

  1. Replies: 11
    Last Post: 07-19-2018, 11:13 AM
  2. Replies: 6
    Last Post: 04-08-2018, 03:45 AM
  3. Replies: 6
    Last Post: 03-17-2017, 10:28 PM
  4. Replies: 1
    Last Post: 10-24-2011, 08:01 AM
  5. Replies: 1
    Last Post: 08-11-2011, 11:33 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