Dear all
I am making student database.
I have following fields;
1. Student ID
2. Branch Code
3. Academic Year
4. Seven Digit ID
Student ID contains full length ID having 13 digits and I want to reduce this ID to last seven digit only and the field is Text type field
I am using VB code as under
Me![Seven Digit ID] = [Student ID]
Me![Card SNo] = "001"
Me![STD Card ID] = [Branch Code] + "-" + [Seven Digit ID] + "-" + [Card SNo] + "-" + [Period]
DoCmd.RefreshRecord
The question is how can I copy [Student ID] (Only last seven digits) into [Seven Digit ID] field?
Thanks in Advance
Regards
Haseeb ul Hasan