Compound fields?

I have two fields, FirstName and LastName, that I would like to combine into a field, Last_First, does access have any specialized way of doing that, or does it just take some manipulating with vba?

Is the combined field a field on the screen, or a field in a table?

For us in a query

SELECT [Table1]![LName] & ", " & [Table1]![FName] AS FullName
FROM [Table1];

To update a existing field in the same table as First and Last

UPDATE [Table1] SET [Table1].[FullName]= [Table1]![LName] & ", " & [Table1]![FName];


S-

thanks very much