Joining two fields into one

  • Thread starter Thread starter Novice
  • Start date Start date
N

Novice

This is probably a no brainer, but don't seem to have one.

I have two tables, Managers and Employees. Each of them
have different properties.

I would like to combine the managers names with the
employees names into a new field. My intent is to be able
to have a drop down box on a form list EVERYONE.

I thought an outer join would work, but I apparently don't
know how to set it up right. The help file does a good
job telliing me what it is, but doesn't show how to set it
up.

I know nothing of VB. I consider advanced Access is not
using the wizards.
 
I have tried your solutions with the Nortwind database, the Employees form.
I have placed one text box control. I have opened the Properties page, and
in the Data tab, Control Source Property, i have inserted the following:
=[FirstName] & " " & [LastName]

NOTE: in the quotation marks is a Space included. If you do not need, space,
simple type =[FirstName] & [LastName]
This is example. You need to change the names to your control names.
 
Back
Top