Im a novice to Access 2003, but getting better. I have a table with three fields in it, ie.. EmployeeID, fname, lname.
What i want to do is to combine the lname field with the first letter of the fname field to create the EmployeeID field. From this; John Doe, to this; Doej.
I know (or think)...