Concatenate field in table

  • Thread starter Thread starter Lp12
  • Start date Start date
L

Lp12

Hi All,
Can I concatenate Full name from FirstName and LastName fields from the
table itself (using default value perhaps) or should I write a
query/procedure do accomplish it?
Thanks a lot in advance
 
If you mean should you store the concatenated name in the table as an
additional field, the answer is no. As with all derived data, calculate it
when you query it, display it, or report it, with an expression such as
this:

Trim(FirstName & " " & LastName)
 
Well you can perform some limited calculations for table values but
unfortunately you can't reference the values of other fields in that table.

If you really need a field that stores that value, you can use a form to
perform the task in its before update event, however, it will only update one
record at a time.
 
Back
Top