I have a numbering system i need to implement for a job databse.
When a user want a new job number they click the said Access 2000 front end button and the next number in sequence has to be given to them.
UK2007 number given would be UK2008
Having problems wrintg this as the cant increment as the type is varchar not int whats the work around
Using SQL server 2000.
I was asuming the button would fire a procedure.
Thanks in advance