Re: [MSAccessProfessionals] I need help to create vba function

I forgot to give context to the function inputs and outputs;

1.- column 1 is a transaction 

2.- column 2 is the starting end of month period the transaction appeared

3.-The third column is the last end of month the transaction appeared

4.- The aim of the function is to return a sequence of all end of months in between, in addition to the starting end of month and the last end of month. and, also evaluate if the transaction is closed or opened. The transaction is closed if the sequenced end of month is not the current end of month, which as of today, the current end of month is 23-02, which means February of 2023.

Thanks for your attention!

On Wednesday, March 8, 2023, anzus101 via groups.io <anzus101=gmail.com@groups.io> wrote:

Hi folks, 

I am rusty on Vba, could you please guide me to create a function as show in the pic below? I invite you a round of coffee to you and your mates. Thanks.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116374) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_