I am trying to set up a simple stock control database as part of my as coursework, and the only problem im having is setting up the validation rule for the stock codes.
the following input mask is used: LL-000-00
So the code must look sumthing like this when inputted: AA-123-45
the last two digits are supposed to be check digits to verify the first two parts of the code. However using access i have not been able to get this to work. It was relitivley easy using excell but i just cant seem to find a way to do it within access.
all i need is a way to seperate the last set of digits really and i can proberbly figure out the rest.
the following input mask is used: LL-000-00
So the code must look sumthing like this when inputted: AA-123-45
the last two digits are supposed to be check digits to verify the first two parts of the code. However using access i have not been able to get this to work. It was relitivley easy using excell but i just cant seem to find a way to do it within access.
all i need is a way to seperate the last set of digits really and i can proberbly figure out the rest.
