J
jhales
I am trying to populate a new field in either a table or a query with
concatenated fields from another table.
For example, the Products field can have values 1, 2 or 3 and the
Services field can also have values 1, 2 or 3. When a user inputs
information into this table a value is selected for Products and
Services. I want the new field to have the concatenation of Products
and Services e.g. if Products = 1 and Services = 2, then newfield =
12.
How do I do this in either a table or a query?
I think this should be simple but I obviously don't know enough Access
and can't find the solution on the web.
*** It turns out it is easy and I've found the solution after further
searching.
concatenated fields from another table.
For example, the Products field can have values 1, 2 or 3 and the
Services field can also have values 1, 2 or 3. When a user inputs
information into this table a value is selected for Products and
Services. I want the new field to have the concatenation of Products
and Services e.g. if Products = 1 and Services = 2, then newfield =
12.
How do I do this in either a table or a query?
I think this should be simple but I obviously don't know enough Access
and can't find the solution on the web.
*** It turns out it is easy and I've found the solution after further
searching.