Good day all experts,
I got a question about excel and/or access table preferably 2003 version but if there is a lot of difference between the 2007I would like a solution to:
I try to compare 1 date field and want to fill in a second date field that calculate the different the first date + 1 month and fill in another field with a Yes/No option in that row.
So this is to calculate an invoice date + 1 month to receive the date overdue in another date field.
I use the yes/no to do further calculations to merge and send out letters for those overdue.
Table 1 Table 2 Table 3 Table 4 Table 5
Invoice date: Date overdue: Amount overdue: Letter to send: Send date
09/06/22 ? 100 Yes/No? ?
I hope this all is clear!