I'm running a group hostel, and to track the activity I created a table that list every client I have, their day of arrival and departure.
When I create a new reservation (new record), I add the day of arrival and departure. And a formula takes out the month and year of the arrival, and a group setting that group the reservations by the month, so I have every reservation group by month.
But I have one issue : when a customer stay on 2 different months (like you can see for client 2, staying in may and june) he is only in the 2023/05 group, and not on the 2023/06 group.
I would like to see client 2 on the 2023/05 groupe AND the 2023/06 group, so when I look at the 2023/06 group, I know he is here.
You can see the table right here. (I remove all of the irrevelvant fields for (as payment tracking, details of reservation ..) to make it more easy to read).
Thank you for your help!