Would you consider sharing that query, I've found ways to get totals, but not the number of canned jobs, and maybe I could do something for you in return, like put a logo on your invoice, even though that is not Mitchell sanctioned.

PS-I use Access 2000 and ... Login to read more.