Hello all,
Question...the database I'm writing monitors several clinical trials (a four digit number/primary key) at a given time. They are assigned a priority number for reports...trial #9999 has priority 1, #9998 priority 2...etc.... HOWEVER, the priority number is reset on a monthly/weekly...