Why? As in "what business need do you have that requires you to redundantly
store data in two tables?" Generally, storing redundant data is not
necessary in Access -- what's being "solved" can often be solved without
resorting to redundant copies of the same data.

And again, why? As in "why do you need to combine data from separate fields
into one?" A tenant of good relational database design is that you DON'T
store more than one fact in one field -- you are describing store two facts
in one field.

If you need to SEE the two fields combined, that's what queries are for.

--
More info, please ...

Jeff Boyce
Access MVP