I am beginning to think that access is more trouble than it is worth. I wanted to find a simpler way to enter and report on my data other than excel but I am getting problem after problem and error after error.
This is the report I will eventually try and create. This is it in excel.
The individual tells me what they did, how long they did it, and how many trips they could get in the time they did the work.
Right now I am trying to build the individual queries I need for the report and am down to the efficiency one. I am getting query is to complex even though it is a simple calculation. EFF1: [Per1]*[utl1] efficiency = performance times utilization.
does access "look back down the chain" or something. I have had to create 4 or 5 other queries to get the performance % and Utilization % I need for this efficiency calculation. This is really getting frustrating.