• 0

I got a question about excel and/or access table


Question

Good day all experts,

dunno if this is the right forum for it??

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!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.