Query/Report Question

[pretoria]

I am trying to combine firstname and lastname in a listbox on a report. It seems to work for my forms but I haven't gotten it work yet for a report. Can someone take a look at my WHERE statement to see what I'm doing wrong. The report is based on the LastLogQuery2

I have the following sql statement

SELECT [LastLogQuery2].[FirstName] + ' ' +[LastLogQuery2].[LastName] FROM [LastLogQuery2] WHERE ((([LastLogQuery2].ContactID)=Reports![CallReport]![ContactID]))

 

[Newman]

I am not sure, but I usualy use «&» instead of «+».
Might give it a try.

 

[pretoria]

I know the first part works because it works with my forms, its the where statement that's not delivering. I'm wondering whether I can at all do this in a report?