Can you offer any more insight as to what you are trying to accomplish?
Typically, it is not good practice to store the same data redundantly, or to
store calculated values. If you need to combine the values for display
purposes, or as a calculation, you can use a query or an unbound control
on a form, etc.
Set the control source of the control on your form to [Field1] & " " &
[Field2]. Obviously, you need to use the actual names of the fields
that are in the forms record source.
Lynn Trapp www.ltcomputerdesigns.com
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.