Hi All,
Problem is to create a generated userID given (via a data entry mechanism) a Forename, Surname and the number from the primary key autonumber fields. In Access 2010 this was no problem to do using Calculated fields in the table definition. I used Left([Forename1], 3], left([Surname], 3) then concatenation with the PK number in a 3rd calculated field. Easy! BUT, I now find that the same thing has to be done in ACCESS 2007, ie no calculated fields in tables. So, I turn to calculated fields in queries? Is that correct? But how do I run an Append query to allow a new student to be added to the database, with the new calculated StudentID. That is, to enter a new row to my Student table with the 'calculated' student ID placed in the field in the table? Or should I be doing something much simpler? All help welcomed!
djcmalvern