Unanswered: starting and ending serial numbers using templates?
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.