I
ispfemme via AccessMonster.com
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!!!
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!!!