create field from two fields
Create a new field where? Are the fields text or numeric?
Do you have a good reason for combining two values into a single value? This
isn't normally good practice.
Do you know how to create a make table query?
Do you know how to concatenate expressions together using syntax like:
[LastName] & ", " & [FirstName]
--
Duane Hookom
MS Access MVP
--
"mackdiva" wrote in message
...
I have a property table and a tenant table. I would like to create a new
field
{propertyID} + {TenantID}. One property might have several tenants or
none
at all. Also this field needs to be a primary key for new table
|