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