Under the Gun Need Help!
Hell everyone. I need some help with code. I have two tables with a 1 to many relationship. So, on my form I show the person and then in datasheet view in a subform I show all their assignments. I would like to be able to display counts of that persons Individual assignments on the main form. For instance, a judge could have 12 criminal cases, 15 domestic and 75 civil cases all listed in the subform. But, I want to show the breakout totals on the main form.
Any Ideas, code would be highly appreciated.