how do i get a calculated value to store in a field in ACCESS?

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

Guest

yes i know that this is discouraged but i need to use a concatonation of
last_name and company_name as a member identifier and for sorting. calculated
info displays on form correctly. how do i get it to store in field?
 
You don't need to store it. Sorting allows you to enter a combination of
fields in reports, queries, and forms. If it is an "identifier" then again,
you can display that in a field in your form, report, or query.

If you want this to be a key in the table, then you can create a "compound
index" where you specify multiple fields to be combined for one index and
then you set it to not allow duplicates.

In all the above, there is no need to store the combined data.

What is a company name changes (lawsuits) or what if a person gets married
or divorced? You'd change the underlying fields, but how would you make
sure the 'calculated field' got updated.
 
Back
Top