CONCATENATE IN A TABLES?

[JeffCita]

In my db I have querries creating a [MemberNumber] consisting of concatenated
fields, ie; [LAST NAME]+Right([SOCIAL SECURITY],4) however this
concatenated[MemberNumber] does not appear in the tables. Is there a way to
concatenate in tables instead of querries? or is there a way to save a querry
level concatenated field into a table without manually entering the data?

 

[Jeff Boyce]

Why? As in "why would you need/want to store data redundantly"?

You already have the data in your two fields. Why add another? And how
will you keep that third field synchronized with the other two if something
changes (folks do get married/divorced and legally change their LastName)?

Access tables store data, Access queries get/concatenate data, Access forms
(and reports) display data.

(That said, there are some unusual circumstances in which it makes sense to
store a calculated value ... but from your description, this isn't one of
them.)

Regards

Jeff Boyce
Microsoft Office/Access MVP