How to create reset a autonumber after every Year

[rahulmanekar]

How to create or reset a autonumber at the start of new Year

Hi I am trying to make a database, In which I have a table linked with the form.
There are two fields in the table 1.Serial Number & 2. Current Year
I want the serial No. field to be incremented after every record is added & Also the numer should start from "1" again as the Current Year Changes.
Can somebody help me in this.
I am learning new things in access & not that proficient. But i love to work in access.

 

[RuralGuy]

AutoNumbers are not appropriate for the use you described. Maybe this thread will be helpful.

 

[rahulmanekar]

Thanks for that, but it only gives you how to generate a autonumber. What should I do to get the number starting again from "1" at the start of every new year.

 

[RuralGuy]

I believe Pat Hartman's comments in this thread are what you are looking for.

 

[rahulmanekar]

Ok I'll try that & let you know, Thank you very much for your help.

 

[RuralGuy]

Post back if you are still having trouble.

 

[rahulmanekar]

Hi, I tried that but didn't worked. Pls find the post with follwing discription.

Restarting Custom # Each Year Using Dmax function

This is what I want. Can you help me?

 

[The_Doc_Man]

There should be NOTHING you have to do if you get a given year to increment.

That is, if you use properly delimited and selective DCount, then the next number is ALWAYS

1 + DCount( "[year]", "mytable", "[Year]=[EntryYear]")

assuming that you have a year in the entry you are about to make. The moment you make an entry for a new year, DCount returns 1. It automatically starts over again.. You have NOTHING SPECIAL to do as long as you design the structure right.

 

[rahulmanekar]

Thanks man, I got that thing......

 

[gear]

Help me please, Mr Rahulmanekar

I want this in my database i.e., the autonumber field should start from No.1 every year. I am not familiar with VB or SQL. Would you please explain how to write the code where to put etc. Shall be grateful.

 

[neileg]

Double posting. In Tables as well!!!!!!!!

 

[rahulmanekar]

Hi just follow this link & download the file....

http://www.access-programmers.co.uk/forums/showthread.php?t=121400

I think this will be very helpful; thanks to the freind who gave me this.....

 

[sameh.abdelkawy]

Thanks man, I got that thing......

Hi,
I'd like to create an auto number for every month and reset it (begin from 1) every month.
Kindly help me in that.
Thanks in advance for your help.

 

[CJ_London]

This is a 14 year old thread - suggest start you own thread as your request is different to the original question

 

[Pat Hartman]

Here's an example. It is a little more complicated than your request so post back if you have questions.

 

[Gasman]

Here's an example. It is a little more complicated than your request so post back if you have questions.

Pat o/p has started own 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]

Here's an example. It is a little more complicated than your request so post back if you have questions.

Yes, but this is not what I want.

 

[Pat Hartman]

You never answered any of the questions I asked in the other thread about whether this was existing data that you were converting or perhaps an input file you get from some other place. You didn't even respond to my question regarding whether you wanted to use this in an append query or if you were intending to use it in a select query.

 

[sameh.abdelkawy]

You never answered any of the questions I asked in the other thread about whether this was existing data that you were converting or perhaps an input file you get from some other place. You didn't even respond to my question regarding whether you wanted to use this in an append query or if you were intending to use it in a select query.

So sorry if I didn't reply or see your questions.
1- Yes it was existing data not an input file.
2- It's a select query not an append query.
Just simple data need to be incremented and reset at every start of the month

 

[Pat Hartman]

Just simple data need to be incremented and reset at every start of the month

This implies that you are trying to update the data. I take it you are NOT updating the data, in which case you already have the answer you need.