C
chrisvic1
I'm working with Access 2002
I'm working on a database where I input information for subjects in a
research study. Each subject gets a special ID number (eg RNF 001, RNF 002,
RNF 003, etc.) I now have 1003 subjects. When I sort the Study ID field in
ascending order it does this: ...RNF 099, RNF 100, RNF 1000, RNF 1001, RNF
1002, RNF 1003, RNF 101, RNF 102, RNF 103... But the ID numbers in the 1000
range should be ordered after RNF 999. Is there any way I can get the ID
numbers in the one thousand range to be ordered sequentially after RNF 999
instead of RNF 100?
I'm working on a database where I input information for subjects in a
research study. Each subject gets a special ID number (eg RNF 001, RNF 002,
RNF 003, etc.) I now have 1003 subjects. When I sort the Study ID field in
ascending order it does this: ...RNF 099, RNF 100, RNF 1000, RNF 1001, RNF
1002, RNF 1003, RNF 101, RNF 102, RNF 103... But the ID numbers in the 1000
range should be ordered after RNF 999. Is there any way I can get the ID
numbers in the one thousand range to be ordered sequentially after RNF 999
instead of RNF 100?