I have a report based on a simple query but the report only shows every other record so I only get half of the reports I need. I am sure it is a simple setting somewhere but I cannot find out why. Here is the database. There are 14 employees in the table, 14 employees in the query derived from the employee table, but the report only shows 7 employees.
I have searched every setting and I can't see why it is doing this.
Any ideas?
I have searched every setting and I can't see why it is doing this.
Any ideas?