Creating Ref numbers from two fields
I want to create an ID code from the first 3 letters of a surname in the surname filed and combine it with a 3 digit number to create a unique ID code. Appreciate it if anyone could tell me how this is done in Access.
Software/Hardware used:
Software/Hardware used:
ASKED:
April 1, 2009 7:42 PM
UPDATED:
April 4, 2009 3:09 PM
Answer Wiki:
I'm not really good at Access but as far as I know triggers are not available in Access but anyway you may use Form events to grab the first three digits with something like MYCODE = LEFT(FIRSTNAME,3) + LEFT(LASTNAME,3)
I strongly suggest you adding more "items" for this ID otherwise it will surely happen that you end up with duplicate IDs.
Another suggestion is to move to SQL Express where you have tons of options and a more professional way of doing things.
Regards.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
