I have a report of truck runs. Each truck run contains a number of items, listed below the truck run. The report always runs yesterday's truck runs, based on the query .
My problem is, I want the report to put the number of truck runs in the report footer. But, it is counting the number of items in the truck, not the truck runs.
I have tried every verion of Count, DCount, etc. Nothing is working. Has taken up half of my day. None of the forums I've read are helping.
Would appreciate any help. BTW, I tried to get total truck runs to calculate in the query, but I just get a bunch of 1's or it totals the truck run numbers (Primary Key)
Screenshots attached...