Hi guys, I hope I explain this correctly as it's a bit of an odd one
We have data in a table, addresses which need letters sent every at set points during the year, for example
Point 1 01/01/20XX
Point 2 01/04/20XX
Point 3 01/08/20XX
This repeats for 5 years (15 letters in total) then it stops completely marking the file as completed. Every time a letter is sent it marks a field ie Letter 1 as Yes so you know the letter has sent, also letter 2 will not send if letter 1 has not been sent.
My problem is new data is entered at new times. so for example the following might happen:
Address 1 entered on DB on 12/12 means letter 1 = 01/01
Address 2 entered on DB on 05/01 means letter 1 = 01/04
And the cycle would go on. but I have no idea to get the query to work on this basis. Can anyone help with this or maybe suggest a better way to do it?
We have data in a table, addresses which need letters sent every at set points during the year, for example
Point 1 01/01/20XX
Point 2 01/04/20XX
Point 3 01/08/20XX
This repeats for 5 years (15 letters in total) then it stops completely marking the file as completed. Every time a letter is sent it marks a field ie Letter 1 as Yes so you know the letter has sent, also letter 2 will not send if letter 1 has not been sent.
My problem is new data is entered at new times. so for example the following might happen:
Address 1 entered on DB on 12/12 means letter 1 = 01/01
Address 2 entered on DB on 05/01 means letter 1 = 01/04
And the cycle would go on. but I have no idea to get the query to work on this basis. Can anyone help with this or maybe suggest a better way to do it?