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?