i am new to access database and trying to build a simple database using order entry template.But I do need to enter another coloum to it which is serial no coloum.
there should be 2 coloums which are starting and ending serial number.
Starting serial number I should be able to input and (starting serail number +the quantity ordered) should give the ending serial number.Since serial numbers are in sequence.

I would very much appreciate if someone could help me with this.