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];


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(E-Mail Removed)
www.pcdatasheet.com


"Alex" <aph@nospam_misnet_.co._.uk> wrote in message
news:(E-Mail Removed)...
> 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];
>
>

Thanks

"PC Datasheet" <(E-Mail Removed)> wrote in message
news:PAdid.17587$(E-Mail Removed)...
> 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 Removed)
> www.pcdatasheet.com
>
>
> "Alex" <aph@nospam_misnet_.co._.uk> wrote in message
> news:(E-Mail Removed)...
>> 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];
>>
>>
>
>