Search results

This worked perfectly when I also included the Month in the sub query and main query, without that it didn't return all the expected records, probably due to techs having multiple months with the same gross hours. Thanks for your help!

Assuming I have the following data in a table Month TechID PlanUnit GrossHours 01/01/2017 10165 CARLI 37.5 01/01/2017 10170 THAMS 112.5 01/01/2017 10487 WATFD 167.5 01/01/2017 10541 IPSWI 160 01/01/2017 10541 TSIDE 80 In instances where any individual TechID has more than one...