Results 1 to 4 of 4
  1. #1
    fede is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    2

    Report with multiple tables

    In a database like this:

    Main table
    ID NAME
    1 JOHN
    2 PAUL
    3 RINGO

    Secondary 1 table
    LINKID INSTRUMENT
    2 GUITAR
    2 BASS
    3 BATTERY

    Secondary 2 table
    LINKID SON NAME
    2 STELLA


    2 JAMES
    3 ZAK

    i want to have a report of this type:
    NAME INSTRUMENTS SON NAME
    PAUL GUITAR STELLA
    ........BASS JAMES
    RINGO BATTERY ZAK

    But if i join tables in a query to create report i obtain this:
    NAME INSTRUMENTS SON NAME
    PAUL GUITAR JAMES
    .........GUITAR STELLA
    .........BASS JAMES
    .........BASS STELLA
    RINGO BATTERY ZAK

    THIS IS JUST AN EXAMPLE, BUT I HAVE 8 SECONDARY TABLES

    How can i do?
    Sorry, but i'm not so good in english as well as in access.

    Thanx in advance
    Federica

  2. #2
    SBlakeS is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2016
    Posts
    3
    I'm not 100% sure what you need but I will do my best. Correct me if I've made incorrect assumptions. Here is what I think your tables should look like in design view:

    Main table
    NamesID
    Name

    Secondary table 1
    InstrumentID
    NamesIDFK
    Instrument

    Secondary table 2
    SonNameID
    NamesIDFK
    SonName

    When you build the relationships, NamesID in the main table should be linked to NamesIDFK in both other tables.

    When you build the report, you will need to choose NamesID (which you can just make small enough to basically hide it), Name, Instrument, and SonName. Create a group based on NamesID. Select all of the fields and, in the properties, hide duplicates=yes. I believe this will give the report you are looking for.

    All that said, I'm new to Access and may have that completely wrong.

    Best of luck,

    Blake

  3. #3
    fede is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    2
    Sorry, i've forgot to say that it was only an example. In reality i have 8 secondary tables, so i think your answer will not work.

    Thanx a lot for your answer

    Federica

  4. #4
    SBlakeS is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2016
    Posts
    3
    Maybe you could give an example that is more closely related to the actual information you need?

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

Similar Threads

  1. Replies: 1
    Last Post: 07-05-2015, 09:23 AM
  2. Replies: 1
    Last Post: 06-09-2014, 02:04 PM
  3. Replies: 1
    Last Post: 04-12-2013, 03:03 PM
  4. Report drawing from multiple tables
    By Palladian in forum Reports
    Replies: 3
    Last Post: 10-08-2012, 04:11 PM
  5. Multiple tables/one record report
    By Smooth Operator in forum Reports
    Replies: 3
    Last Post: 06-24-2010, 09:43 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