I have a query that I need to check a couple of things for one field.
I have two fields within the query "DueDate" and "ConfirmedCPO". Certain tasks are requested that have a due date. If a date is entered in here then the task is not completed until a date has been entered in "ConfirmedCPO".
However I also have another field called "Reminder". This is basically a list of days where the user has the option of listing an amount of days for the reminder. By default this is 14 days, unless changed.
What I need to do is that if date is equal to "DueDate" minus "Reminder" (i.e. 14/4/2005 - 14 days) then the record is displayed, unless a date has been entered in "ConfirmedCPO". I need this to be displayed until a date has been entered in "ConfirmedCPO". I also don't need to display it before "DueDate" minus "Reminder".