spottednewt
Programmer
I have a report that shows employee assignments by the hour. Each record under the hour header has a person's ID no., assignment, a start time and end time.
Now, under the hour footer, I would like to show a subreport that lists all people from the employee table not listed under that hour. I tried making a query with criteria for the IDno
Not MainReport!IDno
The problem is that it excludes only the first person's ID and it allows subsequent people under the hour header to show in the subform. I need the subform to exclude all the employees listed under the hour header. Any suggestions?
Now, under the hour footer, I would like to show a subreport that lists all people from the employee table not listed under that hour. I tried making a query with criteria for the IDno
Not MainReport!IDno
The problem is that it excludes only the first person's ID and it allows subsequent people under the hour header to show in the subform. I need the subform to exclude all the employees listed under the hour header. Any suggestions?
