Trying to return the concatenated value of two fields using a DLookUp

[atrium]

PersonResp: DLookUp( "RTrim([Users].[FirstName] & "" "" & [Users].[LastName])","Users","UserId = " & [Matters].[RespPerson])

PersonResp is a field in my query. I keep on getting an invalid syntax message

Any help would be appreciated

 

[theDBguy]

Maybe you could try it this way:

PersonResp: DLookup("[FirstName] & ' ' & [LastName]", "Users", "UserId=" & [RespPerson])

 

[plog]

Dlookups have no place in queries.

Instead you bring in Users to your query, link it appropriately (UserID to RespPerson] and then just reference the fields you want.

PersonResp: [FirstName] & " " & [LastName]