Autopopulate field based on value in fields in same record

[RECrerar]

I have a table listing users names it has the following fields
Login ID
First Name
Surname
Display Name

The first three are entered manually the last one should be the users initial and surname and therefore it seems something that can be done automatically something along the lines of
=Right([First Name],1) & Surname
But I am not sure if this is right and if so where to put it, any help would be appreciated

(I am now thinking I may not actually need this field here but if it is possible to do this I would still be interested to know how as a learning exercise.

Thanks

 

[RECrerar]

Follow on:

I just found this thread which I think answers my question:

http://www.access-programmers.co.uk/forums/showthread.php?t=154313

So you can't have calculated columns in a table, they are only calculated when you need to use the raw data.

Chear anyway