Ok so I posted this question before but for some reason I could not get it to
work.
What I need is this: Database ID-"dschnabe" can only have 5 "call id" at a
time.
Call ID Assigned Resolved Database ID
755669 05/27/08 05/28/08 dschnabe
754776 05/22/08 05/22/08 dschnabe
751502 05/09/08 05/09/08 dschnabe
747345 04/21/08 04/21/08 dschnabe
746533 04/16/08 04/18/08 dschnabe
746472 04/16/08 04/17/08 dschnabe
745730 04/14/08 04/15/08 dschnabe
741597 03/26/08 03/27/08 dschnabe
738424 03/12/08 03/13/08 dschnabe
738441 03/12/08 03/18/08 dschnabe
737777 03/10/08 03/11/08 dschnabe
737773 03/10/08 03/11/08 dschnabe
737271 03/07/08 03/10/08 dschnabe
737253 03/07/08 03/07/08 dschnabe
283748 03/07/08 03/07/08 dschnabe
847592 03/07/08 03/07/08 dschnabe
948572 03/07/08 03/07/08 dschnabe
348478 03/07/08 03/07/08 dschnabe

In this case at the end dschnabe has 6 call id's on 03/07/08 so that should
give me and "Error" message. How can I count this? I need to know for sure
this guy only works on 5 call id's or less at a time, if not i need to
know,HELP!!!
In my table there are many database id's and call id's so I not only need
this to work for "dschnabe" but for the other 100 users or so.
--
sss