combining two fields

[texas1992]

I know that this should be very elementary but I can't get it.

I need to combine two fields, first name and last name, into one field. How do I do this?

I have tried fname + " " + lname and fname & " " & lname.

Neither one works.

Thanks.

 

[mattkorguk]

fname & " " & lname should be fine. Are you adding the alias?
Fullname: fname & " " & lname

 

[texas1992]

Here is my query:

SELECT tblPl_Employment.EmployerName, tblPl_Employment.Union, tblPl_Employment.Local, tblPl_Employment.LocalCity, tblPl_Employment.YearFrom, 
tblPl_Employment.YearTo, tblPl_Employment.JobTitle, tblPl_Employment.JobDuties, tblPl_Employment.BechtelSite, tblPl_Employment.EmploymentComments, 
tblPl_Employment.UnionYears, tblPl_Employment.JOB_REC_NO, tblPl_Employment.PL_NO, tblPl_Employment.JobUnit, 
[tblPlaintiffs.rplname] & ", " & [tblPlaintiffs.rpfname] AS PlaintiffName
FROM tblPlaintiffs LEFT JOIN tblPl_Employment ON tblPlaintiffs.PL_ID = tblPl_Employment.PL_NO;

The error message that I am getting is:
Syntax error (missing operator) in query expression 'tblPl_Employment.'.

I am using MS Access 2010.

 

[jdraw]

Remove the [ and ] in your statement OR
adjust to

[tblPlaintiffs].[rplname] & ", " & [tblPlaintiffs].[rpfname] AS PlaintiffName

 

[texas1992]

I get the same error.

Thanks.

 

[texas1992]

When I try to view it in design mode the only choices are for pivot tables. I don't know if that helps.

 

[boblarson]

I get the same error.

Thanks.

Post the revised SQL that you ended up with after making the change jdraw had suggested.