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.