Combine Firstname and Last Name (1 Viewer)

[Bigmo2u]

I know this is easy and I have done it before, but just can't seem to wrap my head around it again. Writing the query in VBA.

SELECT (tblOwner.oFirst" & " tblOwner.oLast) AS FullName
FROM tblOwner

Error code is:

Syntax error (missing Operator) in query expression '(tblOwner.ofirst tablOwner.oLast)'.

 

[pr2-eugin]

This is what you need,

SELECT (tblOwner.oFirst & " " & tblOwner.oLast) AS FullName
FROM tblOwner

 

[bob fitz]

Try:

SELECT tblOwner.oFirst" & " tblOwner.oLast AS FullName
FROM tblOwner

 

[Bigmo2u]

Neither one work.

 

[Bigmo2u]

Here is the full code eventhoough this is what is throwing the error:

"SELECT tblProjects.ProjectID, tblProjects.ProjectName, tblProjects.ProjectDescription, " & _
         "(tblOwner.oFirst & " " & tblOwner.oLast) AS FullName, tblProjectType.ProjectTypeDesc, " & _
         "tblPriority.PriorityDesc, tblStatus.StatusDesc, tblTier.TierDesc, tblProjects.PercentComplete, " & _
         "tblProjectType.ProjectTypeDesc, tblProjects.StartDate, tblProjects.EndDate, tblProjects.ChangedDate, " & _
         "tblProjects.Attachments, tblProjects.CurrentStatusComments, tblProjects.TotalTasks, tblProjects.OpenTasks, " & _
         "tblProjects.Active, tblProjects.ActualResourceHours " & _
         "FROM tblTier RIGHT JOIN (tblStatus RIGHT JOIN (tblProjectType RIGHT JOIN (tblPriority RIGHT JOIN " & _
         "(tblOwner RIGHT JOIN tblProjects ON tblOwner.OwnerID = tblProjects.OwnerID) ON tblPriority.PriorityID = " & _
         "tblProjects.PriorityID) ON tblProjectType.ProjectTypeID = tblProjects.ProjectTypeID) ON tblStatus.StatusID " & _
         "= tblProjects.StatusID) ON tblTier.TierID = tblProjects.TierID"

And

lstSQL = "SELECT tblProjects.ProjectID, tblProjects.ProjectName, tblProjects.ProjectDescription, " & _
         "(tblOwner.oFirst" & " tblOwner.oLast) AS FullName, tblProjectType.ProjectTypeDesc, " & _
         "tblPriority.PriorityDesc, tblStatus.StatusDesc, tblTier.TierDesc, tblProjects.PercentComplete, " & _
         "tblProjectType.ProjectTypeDesc, tblProjects.StartDate, tblProjects.EndDate, tblProjects.ChangedDate, " & _
         "tblProjects.Attachments, tblProjects.CurrentStatusComments, tblProjects.TotalTasks, tblProjects.OpenTasks, " & _
         "tblProjects.Active, tblProjects.ActualResourceHours " & _
         "FROM tblTier RIGHT JOIN (tblStatus RIGHT JOIN (tblProjectType RIGHT JOIN (tblPriority RIGHT JOIN " & _
         "(tblOwner RIGHT JOIN tblProjects ON tblOwner.OwnerID = tblProjects.OwnerID) ON tblPriority.PriorityID = " & _
         "tblProjects.PriorityID) ON tblProjectType.ProjectTypeID = tblProjects.ProjectTypeID) ON tblStatus.StatusID " & _
         "= tblProjects.StatusID) ON tblTier.TierID = tblProjects.TierID"

 

[bob fitz]

Sorry. Try:

SELECT tblOwner.oFirst & " " & tblOwner.oLast AS FullName
FROM tblOwner

 

[Bigmo2u]

Bob, I tried that too

 

[pr2-eugin]

You should have mentioned you were working with VBA

         "SELECT tblProjects.ProjectID, tblProjects.ProjectName, tblProjects.ProjectDescription, " & _
         "(tblOwner.oFirst & ' ' & tblOwner.oLast) AS FullName, tblProjectType.ProjectTypeDesc, " & _
         "tblPriority.PriorityDesc, tblStatus.StatusDesc, tblTier.TierDesc, tblProjects.PercentComplete, " & _
         "tblProjectType.ProjectTypeDesc, tblProjects.StartDate, tblProjects.EndDate, tblProjects.ChangedDate, " & _
         "tblProjects.Attachments, tblProjects.CurrentStatusComments, tblProjects.TotalTasks, tblProjects.OpenTasks, " & _
         "tblProjects.Active, tblProjects.ActualResourceHours " & _
         "FROM tblTier RIGHT JOIN (tblStatus RIGHT JOIN (tblProjectType RIGHT JOIN (tblPriority RIGHT JOIN " & _
         "(tblOwner RIGHT JOIN tblProjects ON tblOwner.OwnerID = tblProjects.OwnerID) ON tblPriority.PriorityID = " & _
         "tblProjects.PriorityID) ON tblProjectType.ProjectTypeID = tblProjects.ProjectTypeID) ON tblStatus.StatusID " & _
         "= tblProjects.StatusID) ON tblTier.TierID = tblProjects.TierID"

 

[Bigmo2u]

I know this is easy and I have done it before, but just can't seem to wrap my head around it again. Writing the query in VBA.

SELECT (tblOwner.oFirst" & " tblOwner.oLast) AS FullName
FROM tblOwner

Error code is:

Syntax error (missing Operator) in query expression '(tblOwner.ofirst tablOwner.oLast)'.

I did say it

 

[pr2-eugin]

I did say it

Okay ! My bad try the code it should work.

 

[Bigmo2u]

pr2-eugin, I think you forgot to post the code?

 

[pr2-eugin]

The site is having some problems, try Clearing the cache (CTRL+F5). I have given the code in Post#8

 

[Bigmo2u]

Its not showing it to me after several (CTRL +F5)'s :banghead: :banghead:

 

[Bigmo2u]

Okay, I got it thank you so much!

 

[pr2-eugin]

Glad to help ! Sorry about the mess up, both from my end and the website end.

 

[svuyyuru]

To Combine

SELECT
MyTable.FirstName & " " & MyTable.LastName
FROM MyTable