30, 60 day warnings
one table in my database deals with machines offered to us by salespeople. it has a offer date field which allows for the sorting of offers by date, but what i need to do is create a report that shows me all the offers older than 30 days, as these offers may not still be valid and will need to be checked out with the salespeople who made them. i would then like the option of either selecting "Checked" or "Not Checked" on each offer, if I select the former, then in 30 more days i will get teh same warning, but if i select not checked, it will go onto a new report which lists all machines 60 days or older with "Not Checked" selected in the 30-day warning. please advise, thanks.