I have a report which prompts the user to enter a start date, end date, and a job number. The result is they get a detailed report of truck runs, for each job in that time frame.
The query 'Truck Runs Report' takes the criteria and creates the report. The report works great.
Each truck run is numbered by the Primary Key (ID) from the table 'Truck Runs'. However, my summary field in the report to count the truck runs only counts the lines of truck contents, not the actual truck run itself.
How do I format the expression in my summary text box to count the Primary Key Job Truck run numbers only, and not all the records containing the contents?
In other words: count the occurrences of the truck runs numbers appearing on the report. Hope I'm making sense! Help! Thanks!