I think a query and answer similar to to my problem
has already been posted but as I can not find it
Could someone please help me?
In a database there are three columns,E,F,G.
Column E is headed "Perform Every Calendar Unit"
Column F is headed "Date Last Performed"
Column G is headed " Next Due Date"
What I would like to do is:
If Next Due Date is<= 7 calendar days,delete entire row,
or fill with Red,whichever is most convenient.
Next Due Date would also include 1 calendarMonth,
2 calendar Months ,3 calendar Months,6 calendar Months,
and 1 calendar Year.
Ihope this query makes sense.
has already been posted but as I can not find it
Could someone please help me?
In a database there are three columns,E,F,G.
Column E is headed "Perform Every Calendar Unit"
Column F is headed "Date Last Performed"
Column G is headed " Next Due Date"
What I would like to do is:
If Next Due Date is<= 7 calendar days,delete entire row,
or fill with Red,whichever is most convenient.
Next Due Date would also include 1 calendarMonth,
2 calendar Months ,3 calendar Months,6 calendar Months,
and 1 calendar Year.
Ihope this query makes sense.