I am trying to create a report biased on a query that holds all the variables I need. The problem is that when I try to build that query I keep getting query is to complex error message. This might not be the best solution for the creation of this report.
What I really need is a report that can be filtered by person and date and show the other 11 fields I need. I have tried to follow
http://allenbrowne.com/ser-62.html
and
https://www.access-diva.com/r6.html
but the code is beyond me right now. I am looking for something simpler to follow.
The end result will be a report that has the individuals name and date they worked, as well as all the individual task information.
task, trips, standard, reported time, exceptions, earned time, productive time, un-explained time, performance, utilization, and efficiency.
All the individual queries to generate these calculations have been built, I just can't find a way to put them all together into one cohesive report.