Trying to recreate some reports from 2016 into 2020 and the JTD field is kicking my ass when the client has more than one subcontractor doing work in the same cost code.
If I only link the JC_JobCostCodeDetail file (need it for the Estimate) to the JC_JobCostCodeHistory file by the Job/Cost Code/Cost Type, I get multiples of the subcontractor totals (if 2 subcontractor works, I get twice as much, if 3 worked I would get 3 times as much) and if I link the vendor fields, I get nothing EXCEPT the subcontractor information on the report.
I've tried adding another group by Vendor, or Vendor+Year+Period, but again, if the vendors worked in the same period - I'm still back where I started.
I'm sure I'm missing something easy that will make these last 4 reports suddenly convert a whole lot easier, but right at this moment, I'd ready to throw something breakable against the wall.
I know as a last resort on this report I could do subreports, but one of the other reports I have left does some percentage stuff that makes subreports impossible.
Any suggestions will be warmly appreciated. :-)
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------