sameh.abdelkawy
Member
- Local time
- Today, 16:37
- Joined
- Dec 18, 2021
- Messages
- 46
Hi every one,
Thank you all for your posts and help, but none of the solutions helped me in solving my problem.
In the attached file you will find the exact example which I mean by increment and reset every new month.
When opening "Table1 Query", you will find 1,2,3,4 and 1,2,3 depending on "DateArrived"
I need that in Access wherever in Query or else.
When I choose date, the MonthID will read this data and continue as it is or will be reset when it comes to new month.
Thanks
Thank you all for your posts and help, but none of the solutions helped me in solving my problem.
In the attached file you will find the exact example which I mean by increment and reset every new month.
When opening "Table1 Query", you will find 1,2,3,4 and 1,2,3 depending on "DateArrived"
I need that in Access wherever in Query or else.
When I choose date, the MonthID will read this data and continue as it is or will be reset when it comes to new month.
Thanks