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

It would have helped if you included the image from your previous email since you forced us to glance back and forth. I would start with a table of all of the month periods.  Use this tblMthPeriods with your main table and set the criteria under the new MthPeriod field to Between cds_open_or_created_eom and cds_last_snapshot_eom. This will display a duplicate record for every month period from the start to the end.

Get this correct and we can proceed with other issues.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of anzus101 <anzus101@gmail.com>
Sent: Wednesday, March 8, 2023 8:55 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: 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.