Results 1 to 2 of 2
  1. #1
    Thomisa is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Location
    Georgia, USA
    Posts
    1

    Report with subforms and subsubforms

    I work in a law enforcement field and I'm trying to build a database to show crime series. On the top of the report, I want maps, title, and dates of the series which will have multiple related crimes. As a subform related by CID, I want the case number, dates, times, and other details of each individual crime. As a sub subform related by Case Number, I want details such as vehicle descriptions, suspect descriptions, items stolen, and other details. All the tables, forms, and query's have been built, but how do I put this all into a report?

    I've attempted by making a crimes report with has the suspect, vehicle, and items queries embedded. I this drug this to the main report called series. This provided a "Cannot open any more tables" error.



    Any advice is welcome....

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I see that this is marked Solved, but if it is not solved, maybe you would post your dB (minus sensitive data) to makes it easier to help with the report??

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

Similar Threads

  1. Replies: 5
    Last Post: 12-12-2016, 07:23 AM
  2. Replies: 7
    Last Post: 02-24-2015, 12:04 AM
  3. Replies: 10
    Last Post: 05-29-2013, 11:39 AM
  4. Replies: 16
    Last Post: 04-01-2012, 01:42 PM
  5. Replies: 0
    Last Post: 02-28-2011, 09:46 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