When I started this project, it never occurred to me that THIS is where I would have a problem, but now that I am here, I realize I have no idea how to accomplish this.
I have a database that is tracking Judge assignments on cases. What I would like to have happen is have a query or report that shows two things, the number of cases assigned to a certain Judge, and which Judge is next up for case assignment, based upon the number of assignments and the date they were assigned.
I have one table with the Judge's names with their Bar numbers as key, and then another table that references that one for the Judges from a dropdown box and the case information, for example
Judge Case_Number Defendant Date_Assigned
Jones 11111 Billy Thompson 1/1/11
Smith 11112 Craig Ferguson 1/2/11
Tyler 11113 Matt Borsch 1/3/11
Jones 11114 Dennis Mitchell 1/4/11
I really appreciate any help I may receive. Please let me know if you need any more information.