i'm trying to concatenate two fields in a query and i'm getting asyntax error. could someone put me straight please? i've tried the following...
name: firstname&lastname
name: firstname & lastname
name: [firstname]&[lastname]
name: firstname&lastname
name: firstname & lastname
name: [firstname]&[lastname]