Results 1 to 2 of 2
  1. #1
    Steelersfan26 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2017
    Posts
    5

    Need help with design

    Hello...need some help with the best way to design this database...here's what it consists of:



    I have 3 main sections(1,2,3), and 4 subsections (A,B,C,D) under each of those main sections. The 4 subsections are the same for each main section.
    I need to track inspections. Each subsection contains about 10 inspections; inspecting various elements such as safety, training, etc.

    What is the best way to set up my tables and forms to differentiate between the sections and subsections, for reporting purposes?

    I need to run reports based on 'upcoming', 'overdue', and 'date completed'

    Currently I have a main page that lists the Subsections with a dropdown next to them to select which checklist/form to open. In the form the user selects their Main section and fills out all other subsequent data.

    That format seems ok, but I am having issues running those reports.
    In the reports section, I have them select a Main section and a Subsection from two dropdowns.
    In the query I use 'Like "*" & [Forms]![frmMain]![Combo57]& "*" ' to filter the report to the dropdown of the Main section. I have tried various options in the 'Next Due' and 'Date Completed' fields to try and filter for what I need, but it always just pulls everything from the table.

    Hopefully I explained that well enough. Thanks for the help!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you may want an inspection table to track each:

    tInspections
    -----------------
    InspectID (auto)
    Section
    SubSect
    InspectType (safety, Train)
    Date2Inspect
    DateInspected
    InspectedBy

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

Similar Threads

  1. Design Help
    By Brightspark98 in forum Access
    Replies: 9
    Last Post: 01-05-2017, 08:11 AM
  2. Design vs Article (=Design+Materials) problem
    By emihir0 in forum Database Design
    Replies: 14
    Last Post: 04-20-2015, 03:03 PM
  3. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  4. Help with Design
    By rbiggs in forum Database Design
    Replies: 8
    Last Post: 07-10-2011, 07:13 PM
  5. Design help
    By jacko311 in forum Database Design
    Replies: 0
    Last Post: 11-12-2009, 05:57 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