- Local time
- Today, 10:51
- Joined
- Jan 23, 2006
- Messages
- 15,385
Tim,
I just used a table that I had. It has a field pName that has both First and Last Name in that field. I my example there was no concatenation as such -- for example a couple of pName values were
Polly Dactyl and Ura Payne. I would not normally put both First Name and Last Name in one field.
If the PersonNames table had FirstName and LastName as separate fields, then you would select both and you will get the appropriate values for InspectorsName.FirstName, InspectorsName.LastName, as well as PersonsNames.FirstName, PersonsNames.LastName etc.
Bottom line there was no concatenation.
Sorry for any confusion.
I just used a table that I had. It has a field pName that has both First and Last Name in that field. I my example there was no concatenation as such -- for example a couple of pName values were
Polly Dactyl and Ura Payne. I would not normally put both First Name and Last Name in one field.
If the PersonNames table had FirstName and LastName as separate fields, then you would select both and you will get the appropriate values for InspectorsName.FirstName, InspectorsName.LastName, as well as PersonsNames.FirstName, PersonsNames.LastName etc.
Bottom line there was no concatenation.
Sorry for any confusion.