I am totaling trucks and spares for the company on one report. I have the total for the company but cant figure out how to do the individual plants on same report.
=Count([DName]) I have this in a text box located in report footer to get company totals for number of drivers
=Count([TruckNumber]) I have this in a text box located in report footer to get company totals for number of trucks
=Sum(IIf([TruckAssigned]="no",1,0)) I have this in a text box located in report footer to get company totals for number of spare trucks
I need to get these same totals on the report but at the plant level and cant seem to figure out how
Thanks for any and all help