Multiple fields in combo boxes

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Is this possible please.
i have a combo box on a table which looks up data from another ytable, which
conjtains a FirstName and Surname field.
I want to concatanate the two fields together and place them in a field
within the first table.


My current code is this
Using: SELECT Lecturer.LecturerID, Lecturer.FirstName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];
 
SELECT Lecturer.LecturerID, Lecturer.FirstName & " " & Lecturer.Surname As
LecturerFullName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];
 
Thanks

PC Datasheet said:
SELECT Lecturer.LecturerID, Lecturer.FirstName & " " & Lecturer.Surname As
LecturerFullName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Alex said:
Is this possible please.
i have a combo box on a table which looks up data from another ytable, which
conjtains a FirstName and Surname field.
I want to concatanate the two fields together and place them in a field
within the first table.


My current code is this
Using: SELECT Lecturer.LecturerID, Lecturer.FirstName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];
Click to expand...
Click to expand...
 
Back
Top