Simple Question?

  • Thread starter Thread starter tbrogdon
  • Start date Start date
T

tbrogdon

I have a form with a command button connected to a query that returns
a recordset in datasheet view.

One of the fields is EmployeeID which corresponds to
tblEmployee.EmployeeID which likewise corresponds to
tblEmployee.FirstName and tblEmployee.LastName.

As it stands, when I run the query, I have field EmployeeID in the
returned recordset. I would like to have the employee's concatenated
full name instead.

Is this possible?

Thanks,

Tim
 
Just write "Select tblEmployee.FirstName & " " & tblEmployee.LastName from
tblEmployee"
 
And what would be really great is if the returned concatenations were
in dropdown box format to where when the user selects a name from the
drop down the EmployeeID is actually recorded instead of the
concatenation.

The purpose of this query is to allow the user to review production
data for the day and make any necessary changes to it (e.g., the name
of a peron who ran a particular part)

Any suggestions are most welcome. Thanks.

Tim
 
Put a combo box and in the row source type Select table/query and put the
query "SELECT tblEmployee.EmpID, tblEmployee.FirstName & " " & tblEmployee.
LastName AS Name
FROM Employee; and in format-Column Count as 2 and Bound column as 1(which
will be Employee Id) and in width as 0cm;4cm and thats it
"
 
Back
Top