Dlookup problem

[metronometro]

Hi everyone, I'm italian so apologises for my bad english.

I'm tryng a dlookup function in a Query based upon a table. The table is [Users] and has the following fields:

User_id, First Name, Last Name

.

Now if I want the query to return the First Name, or last Name, specfying a criteria, (User_id=1) it works.

I use this expression in SQL

SELECT DLookUp("[First Name]","Users","User_id = 1") AS Espr1;

But I'd like dlookup to return the FULL NAME in a single field. I've tried

SELECT DLookUp("[First Name]" & " " & [Last Name]","Users","User_id = 1") AS Espr1;

It doesn't work. Where do I mistake? Any suggestion will be appreciated

[aytee111]

Missing quote before Last Name