G
godseyj
Guest
Ok chaps heres the deal. I have a database for my Human Resources Department. Basically we track personnel information, When people leave and Awards that people receive. Well my boss wants a report that shows people scheduled to leave and if they have been submitted for an award and the timeliness on the award. EX. (name) John Doe (loss Date) 1 Jan 02 (Type award) ARCOM (Due to HQ) ----- and (Due BN) ----- ok these last two dates are the hard part. There are about three different type awards. Each one s due to "HQ" and "BN" at different times, i.e. ARCOM is due to "HQ" 60 days before the "loss Date" But due 45 days before to "BN" AND the amount of days depending on the award is different. Now... hope I havent lost you. I have a report made that draws from a query of two tables. [Personnel Data] and [Awards Archive]. Basically is already shows Name, Loss Date, and Projected Award, I need to have two more that say "Suspense to BN" and "Suspense to HQ" I want these dates to automatically back up from the "Loss Date" depending on "Projected Award" Can you help pa pa pa please!!!!!!!!!