Results 1 to 3 of 3
  1. #1
    michbri is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2015
    Posts
    2

    Record missing from report but shows in query and table


    Hello, I'm a very new Access user. I created a report that gets information from a select query; the report is not including all of the records. In the table each record has ID, employee, date, building, hours. It is completed throughout the pay period by the user entering in the table. When pay day comes the user opens the report, entering Start Date and End Date of the pay period then the report is organized by employee, building and sum of hours for the pay period at that building. For any records that are identical e.g. employee worked at same building, for same amount of hours, on same date the second entry is not included in the report although it is showing in the query that the report is based on. What can I do to ensure that the second entry is not lost between the query and the report? Please give me detailed instructions so I can follow easily. A big thanks for any suggestions!

    We do have a work-around but I'm really curious as to what I've done wrong in the creation of the report.

  2. #2
    michbri is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Mar 2015
    Posts
    2
    I guess typing out my issue made me brilliant or something! I figured it out. So, for anyone else who has this issue, my solution was to ensure that the Query had the ID included. I guess that causes the Query to see the two entries as individual entries so includes both.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Is the RecordSource an aggregate (GROUP BY) Totals query? Why?

    Do you have textboxes in the report Detail section?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Table shows deleted record but it won't delete
    By khughes46 in forum Access
    Replies: 3
    Last Post: 09-19-2014, 09:35 AM
  2. shows previous record on report.....
    By shah1419 in forum Reports
    Replies: 0
    Last Post: 08-28-2013, 02:22 AM
  3. Data in query table missing from report
    By nick.muir2 in forum Reports
    Replies: 2
    Last Post: 07-10-2013, 05:18 PM
  4. Replies: 3
    Last Post: 04-13-2012, 10:39 AM
  5. Replies: 5
    Last Post: 10-15-2010, 01:19 PM

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