Solved Reset Autonumber Every New Month

[sameh.abdelkawy]

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

 

[theDBguy]

Hi. Merry Christmas!

Did anybody already suggest this approach?

 

[Gasman]

This is NOT what you asked for in the other thread?

Reset Inceremental Number Every Moth

Hi there, I need to create a query to solve this problem: When entering a new product in the month it has a new serial number starting from 1. This number increments with every new product till the end of the month. A new product in the new month will get a new serial beginning from 1 again. I...

www.access-programmers.co.uk

 

[sameh.abdelkawy]

This is NOT what you asked for in the other thread?

Reset Inceremental Number Every Moth

Hi there, I need to create a query to solve this problem: When entering a new product in the month it has a new serial number starting from 1. This number increments with every new product till the end of the month. A new product in the new month will get a new serial beginning from 1 again. I...

www.access-programmers.co.uk

I know it is a little bit different. But That's what I need for now

 

[Gasman]

Well theDBguy has given you the solution?

 

[sameh.abdelkawy]

Hi. Merry Christmas!

Did anybody already suggest this approach?

Hi,
Merry Christmas to you too!
You, Mr. theDBguy, solved my problem.
Excellent work. Thank you so much!
Happy new year!

 

[sameh.abdelkawy]

Well theDBguy has given you the solution?

Yes he did an excellent work on it.
Thank you all so much for your help.
Merry Christmas and a happy new year to you all.

 

[theDBguy]

Hi,
Merry Christmas to you too!
You, Mr. theDBguy, solved my problem.
Excellent work. Thank you so much!
Happy new year!

Glad to hear you got it sorted out. Good luck with your project.

 

[Pat Hartman]

I know it is a little bit different. But That's what I need for now

Do NOT start new threads when you don't like the suggestions.
If you can't state the requirement accurately, you will never get the answer you want.

 

[sameh.abdelkawy]

Do NOT start new threads when you don't like the suggestions.
If you can't state the requirement accurately, you will never get the answer you want.

I'll take care next time. Sorry for that.