Combining first and last name

[JRINC]

I have been given a table of employees to add to a database. First and last names are in seperate fields. I want to combine them on a form that I am using for entering expenses for each employee.



I created a query with EmployeeID, FirstName, and Lastname. I used that query in a combo box. When I click on the drop-down, it shows both name fields, but only the First Name remains. Probablywould be good to show ID and name fields in final choice, since there could be two John Smiths for example.

Thanks for the help! Using MS Access 2007.

[pbaldy]

How about this as the combo row source:

SELECT EmployeeID, FirstName & " " & Lastname AS FullName
FROM TableName

[JRINC]

Thanks very much

[pbaldy]

The syntax error may be coming from the lack of a space before FROM. The FullName field is only created in the query, for display to the user.