C# Question

Question

Hi There

I am trying to add 1 to the next number in a sequence that is in my Access Database.

So for example the last Number is 0001, and I want to auto increment to 0002 when the user adds a new record. How can I do this? I have 2 columns, CurrRefNumber and CurrYr, So the outcome I want is CurrRefNumber and CurrYr to be put together.

Like 0001/07, and then when a new record is added it will become 0002/07, 0003/07 etc etc

I am completely stuck now :-( Can someone help

Cheers

Jan Montano · Answer

I guess you have to do this manually. Before inserting a new record check first the CurrRefNumber of the Last Entry in the database. how far have you gone through?