Originally Posted by
MikSpeck
Okay, with programming.
On the table that has the student names make sure you have a field for the Student's First name and a field for the student's last name. (In this example fields named, Student and Student LastName.)
Create three calculated text fields on the same table. In this case Field1 and Field2 and Field3.
Let's start with Field2, right click your mouse over Field2 go to Modify Expression and paste the following . . . Left([student],1)
Field3 go to Modify Expression and paste the following . . . Left([student lastname],1)
Now Field1 go to Modify Expression and paste the following . . . [field2] & [field3] & [id]
Add some students first and last names on the tables fields for testing.
Create a query and reference Field1.
Open Query, is this what you are looking for??