Save Calculated Value

[wilson51]

I have table (Customers ) with fields FirstName; SecondName; LastName;. From an input form I need to save the full name (calculated from LastName; FirstName, SecondName).

My simple question Is how do I save the calculated value to the field named Borrower in the Customers table.

I know calculated vales should not be save but this is critical to my database.

Thanks

 

[Joe4]

You can do this in Access with an "Update Query". Check out the documentation on this in Access help (under "Action Queries").

 

[mdmilner]

An update query will do this just fine - will get your entire table regardless of size in one fell swoop, in fact, but, I was thinking about your question.

You wrote that the concatenated (not calculated) value was critical to your database.

Why?

As a quick suggestion/answer - have you ever thought about setting up a query based on your table that concatenates the fields -- and then having whatever it is that *must* have this field value use the query instead?

Concatenation is very simple.
Using QBE (that interface under the query tab that shows you each field) just type this into a blank fieldname.

fldname: fld1 & ',' & fld2 & ',' & fld3

Substitute the fieldname you wish to use for fldname and the last/middle/second name for fld1/2/3. Tweak this line however you need it exactly, including adding spaces beside the commas to make it appear as you need it.

Mike

 

[wilson51]

Mike,

I rather new at Access and I have expanded my knowledge through forums and "Access 2000 Bible".

My database consists of numeraous tables including PersonalCustomers, BusinessCustomers. For each of these I have tables DiaryNotes(BusinessCustomers) & DiaryNotes(PersonalCustomers). I have used the concatenation (QBE) to pull together information for the DiaryNotes.

The challlenging part (for me) is using PersonalCustomers & BusinessCustomers in a Loan table where, for each loan, there could be say up to 5 PersonalCustomers or a BusinessCustomer plus 4 Personalcustomers. For each loan one borrower is designated the PrimaryContact.

PersonalCustomers and BusinessCustomers can be involved in more than one loan and I have multiple loan types.

The loan table is simplistic in that its not designed for any calculations.

I want to be able to run a report for each loan showing all borrowers, loan details( 9 fields of info) and the DiaryNotes relative to each borrower in that loan.

If I have a Borrower field in PersonalCustomers table it will help with setting up the relationships.

This is becoming bigger the Ben Hur.