Concatenation in a table 1

[AccessComp]

I want to concatenate two fields from a table in the same table - fname and sname to name

How can I do this?

 

[Remou]

As in an update query?
[tt]UPDATE Members SET Members.FSName = [fname] & " " & [sname];[/tt]
(By the way, it is not a good idea to call a field 'Name')

 

[AccessComp]

Thanks for the reply -

I need it when I am entering the data into the table.

The word "name" was for example - It will be "DeficiencyUser

 

[Remou]

Then I think you can only do this with a form.