darthpaul
07-19-2007, 10:57 AM
The database I have create is very simple, I am calculating the number of checks printed for each job an operator prints, which is just a matter of subtracting the begining number minus the starting number plus 1. There is also the possibility of spoils and these are added to another table. I want to create a printed report for each job printed, "Company Name", "starting number", "ending number", "total checks" and "spoils". I want to show a single entry for each job but how do I display the spoils when I don't know how many there will be if any?