Hi all,
I have a really simple query, which populates four fields in one of my tables:
UPDATE [Personnel Records]
SET
[Personnel Records].[Full Name] = [First Name] & " " & [Last Name],
[Personnel Records].Initials = Left([First Name],1) & Left([Last Name],1),
[Personnel Records].[E-mail Address] = [First Name] & "." & [Last Name] & "@DEMO",
[Personnel Records].Username = "DEMO\" & [Last Name] & Left([First Name],1);
The query is initiated when I hit the save record button (a macro)
How do I update just the current record instead of the entire table?
I don't want to calculate these values within the table itself (although I am aware that you can do this with Access 2010), as eventually all of my tables will be moved to SQL, and the forms and queries will be packaged.
Thanks!