Results 1 to 9 of 9
  1. #1
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142

    record not showing on report

    on my data base I enter associate information about their jobs every day. Today I had one guy who was not showing up on my daily productivity report even though I could bring him in on the associate individual report. I looked into it and was able to determine there was something wrong with his third daily task record. Primarily in the daily exceptions table. When I removed that record he would show up on the report. When I tried to go back in and add it again he would disappear again.

    my final solution was to go from table to table and delete him completely from all of them and then start over and put him in. I don't understand how his record could become corrupt like that? Any thoughts? I have included both the old and new DB for comparison if you want go.

    The report is the daily procuctivity report. shift is 1st and date is 11/20-11/20.
    Person in question is Banta, Ron
    three tables are
    tblworkdays


    tbltaskactivities
    juncttasksexceptions
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    If you are using inner joins and he does not have a record in the subtable, he wont show.
    make the query an OUTER join to show all folks without records in the subtables.

  3. #3
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    I have been using the DB actively for a little over a week now and this is the first time this has happened. IM not sure what went wrong but after I totally removed his record for yesterday from all the tables and then just re-entered him everything fixed itself. IT's weird.

    Is there a quick way to remove a particular record if you need to and then re-enter it? Some how to look up by name and date and delete that whole record?

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Remove the green link. Makes no sense to try and match these values.
    Click image for larger version. 

Name:	link.jpg 
Views:	6 
Size:	36.9 KB 
ID:	36286

  5. #5
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    I had a question concerning this a little while back. I was having kind of the opposite problem with people being displayed on the productivity report more than once. if they had two task for the day they would show up on the report twice. three task - three times. The advice I was given was to add the green link on that query to allow the DB to know which individual tasks unreported time when with which task. Creating that link solved the problem so that no matter how many task an associated does in a day they are only placed on the daily productivity report once.

    Code:
    https://www.accessforums.net/showthread.php?t=74442

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    The advice I was given was to add the green link on that query to allow the DB to know which individual tasks unreported time when with which task.
    I didn't see any such advice there, and it was my response.
    Have you tried removing the link?

  7. #7
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    Oh I see what the difference was. originally i just had sumofreported time linked. on qryweekly I added wdworkday_PX and linked those two but never removed the sumofreported link. I removed it and it is still only giving me one record per name. So you think that was why that other record was not showing up?

  8. #8
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    So you think that was why that other record was not showing up?
    Well, if it's showing up now, indeed I do.

  9. #9
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    I re-downloaded the problem file and took the link out of the query and yes the problem fixed itself. The associate who was not showing up did show up. thanks for all the help.

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

Similar Threads

  1. Replies: 5
    Last Post: 02-13-2018, 01:57 PM
  2. Replies: 9
    Last Post: 08-08-2016, 02:57 PM
  3. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  4. Replies: 9
    Last Post: 10-21-2011, 08:38 AM
  5. Report showing duplicate record
    By cwwaicw311 in forum Reports
    Replies: 13
    Last Post: 04-07-2010, 04:00 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