Results 1 to 2 of 2
  1. #1
    GOProductions is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    5

    Post Creating a Report that Displays Multiple Subdata Entries

    Hey everyone,



    This may be a stupid question, but I've kind of hit a brick wall. I have a database that I'm creating with the sole purpose of alphabetizing an entire glossary. How the glossary will appear is it will start with Sections, then list Subsections below the Sections. However, some (not all) Subsections will have Subparts. There are (of course) 3 tables: tblSections, tblSubsections, and tblSubparts. Here is what the relationships look like:
    Click image for larger version. 

Name:	GlossaryRelationships.png 
Views:	11 
Size:	9.2 KB 
ID:	28741

    Now, creating a query for just the Sections and Subsections works just fine for the report; it lists each section in alphabetical order, then the subsections as well. However, when I start adding cells from the Subparts table to the query, the query begins to... freak out (so to speak). I'm scratching my head at this point, and it's probably a simple solution, but I just can't seem to think of one.

    My end goal is to have the report list out Sections, Subsections, and for some of the entries, Subparts. Any ideas? Here is the link for the .db file (It's 540kb, just 40 kb over the limit for Access Forums). https://drive.google.com/file/d/0B-i...cwTzVUQ2M/view

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Please attach db, not all of us have access to "other" pages.

    What do you mean by your query "freaking out"? It looks like your query can mirror your relationships - all sections with only those subsections that exist for those sections and only the parts that exist for the subsections. Sounds simple enough. Your report will then show all the data from the query. Get the query working first, then use the report wizard to create a report based on it.

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

Similar Threads

  1. Replies: 6
    Last Post: 05-17-2017, 09:26 AM
  2. Report displays data multiple times
    By kermit in forum Reports
    Replies: 2
    Last Post: 05-11-2015, 03:50 PM
  3. Replies: 4
    Last Post: 06-12-2014, 03:06 PM
  4. Subdata report
    By jenncivello in forum Reports
    Replies: 9
    Last Post: 11-30-2012, 12:45 PM
  5. Replies: 27
    Last Post: 08-14-2012, 09:05 AM

Tags for this Thread

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