If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CONCATENATE IN A TABLES?
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? |
#2
|
|||
|
|||
CONCATENATE IN A TABLES?
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 "JeffCita" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|