Greetings,
I have a table that have entries labeled alphabetically and numerically (ie: AP04001, AP04002, AP04003). The "AP" will always stay the same, "04" is for the current year, and the last three numbers correspond to the entry number. I am having a problem when it comes to anything over 999. For example if a job is labeled AP041000 it won't come after AP04999 in the table. It will be after AP04100. How can I fix this? Thanks
I have a table that have entries labeled alphabetically and numerically (ie: AP04001, AP04002, AP04003). The "AP" will always stay the same, "04" is for the current year, and the last three numbers correspond to the entry number. I am having a problem when it comes to anything over 999. For example if a job is labeled AP041000 it won't come after AP04999 in the table. It will be after AP04100. How can I fix this? Thanks