Results 1 to 3 of 3
  1. #1
    stosh59 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    8

    Status reports

    Full disclosure: I am an Access wannabe. So I barely know what I am doing.

    I am trying to move a weekly status report from Excel to Access. Reporting will be easier as will analysis. I have four tables:

    1) tblProject:
    tablekey (PK)
    ProjectID
    Tower
    ProjNam
    PM
    Start


    End
    Status
    CmntID

    2)tblPM
    pmID (PK and linked to PM in tblProject)
    PMFnam
    PMLnam

    3) tblStatus
    StatID (PK and linked to Status in tblProject)
    StatNam

    4) tblComment
    ProjectIDCmt (PK and linked to ProjectID in tblProject)
    CommentID
    Comment (memo)

    My need is to be able to keep a history of comments by projectID. So for instance, I have project "X". It starts on Jan 10 and will end on Feb 27. Each week I need to add comments about the project status. I also need to be able to see the comment history for project X throughout the project life and even after it ends.

    My problem is I can't figure out how to link the comment table to the project table and maintain that history. I have been unable to tie the comments to a particular project. What am I missing?

    Thank you in advance.

  2. #2
    LillMcGill is offline Dagny fan
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Oct 2010
    Location
    Southern USA
    Posts
    70
    In the Comments table, CommentID should be the PK. (With Proj as the PK, you can't enter multiple comments for a project.) Leave the join to ProjectID as it is. Add a CommentDate field.

    ProjectID is the PK in the Projects table, right?

  3. #3
    stosh59 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    8
    Thanks. The CommentID was going to be a date since comments are entered weekly (e.g., 20110107).

    No, ProjectID is not the PK...but based on your question, I am thinking I should change that. Is that the recommendation?

    Thank you, Lill, for responding so quickly. Your suggestions fixed the problem!!!
    Last edited by stosh59; 01-07-2011 at 03:33 PM.

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

Similar Threads

  1. Check Box status
    By NOTLguy in forum Forms
    Replies: 5
    Last Post: 11-27-2010, 08:59 PM
  2. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 PM
  3. Quering to find a status
    By dbuck in forum Queries
    Replies: 5
    Last Post: 09-08-2010, 02:48 PM
  4. Help with reports
    By geetha001 in forum Access
    Replies: 0
    Last Post: 01-21-2009, 08:45 AM
  5. Replies: 0
    Last Post: 09-25-2008, 12:19 PM

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