put them into one (address) in an existing database
Your post could be a little clearer. If by this you mean within the same database they're already in, what you need to do (if you're not already doing it) is base your forms/reports off of queries based on your table(s) which you should do routinely anyway. Then, in
Design View for your query, create a calculated field like this:
CompleteAddress: [Addess_1] & " " & [Address_2]
Now, in your forms/reports, simply use the created field
CompleteAddress, like you would any other field. That's all you'll need to do, no
Update Query needed.
Parsing the whole name into last name/ first name will require a little more effort, depending on the current format of this field. We need to see how it's currently formatted, i.e.
John Smith
Smith, John
Smith John
and whether the names have Mr/Mrs/Ms before as well as Jr/Sr/III and so forth afterwards. Obviously, the more complications beyond the simple first name and last name, the more difficult/less successful efforts will be to parse the names without human intervention.
Linq
;0)>