If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Generate warnings based on Date
I have a date field in a table called Master that holds the primary
information. I also created a table called AuditStatus that pulls 2 fields from the Master table (the SupplierName and the AuditDueDate) while adding in other fields that are updated once a query is run. Now I have one query that will update the AuditStatus table with any of the values from the Master table where the AuditDueDate is =Date()+60 ; Basically It is looking for anythign that is within 60 days of the current date plus anything that is also past due. This works fine so far. Now here is my problem - I would like to have a way of creating one query where I can simply pull all the values from the AuditDueDate table based on the AuditDueDate. Anything within 31 - 60 days into the future, it would generate a level 1 warning in the form of prompting the user to make a phone call. 16 -30 days would be a level 2 warning and cause for an letter to mailed and another call. Any thing from 15 days or any earlier would be the last warning and prompt the user to send out an email, mail the letter, and make the phone call. From that point, with no response, the user has to change the status of the supplier to inactive. I know how to use the Between Date()+15 and Date()+30; I'm just wondering if I can combine this warning message to be generate in one query. I have a form for each supplier that would list all the possible values and parameters my company associates with them... I'm just hoping that if warning2 is true, could I also have a function that highlights that value on the form... I hope I gave enough back ground information too Thanks!!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
Thread Tools | |
Display Modes | |
|
|