Calculated field to update table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new on doing this so I am not exactly sure how much info you will need
but this is my situation.

I have a table named therapist, in the table there is a column for the
therapist full name. Well I have a form linked to this table and I built an
expression which draws up the therapist First and Last name( This is in the
form) . I can't figure out how to get this info to automatically update the
table like the other fields do.

Please Help Me
 
You don't.

In the table you should store the parts of the name (lastname, firstname,
middlename) and that's all. Storing the full name ALSO would be redundant.
It would also open you up to all kinds of problems. What is someone gets
married and changes their name. What are the chances that the user will fix
both fields?

Instead, when you need the full name, simply construct it in an unbound
field on your forms or reports, or create a new column in your query to do
so.

FYI - This is a very common question. In the future, you might want to read
the previous posts before adding a new thread. That is why the posts are
stored out there. Google also has a "groups" section that is great for
searching.
 
Why would you need to do this? You should have the therapist first name as
one field in the table and the last name as another field in the table. Then
you could use a calculated field on the form to call the data.
=[firstname] & " " & [lastname]

Tom
 
Back
Top