SQL Concatenation

Hi,

Can anyone help me with this no doubt simple query.

SELECT Authors.authorID, Authors.lastname, Authors.firstname, [firstname] & " " & [lastname] AS fullname,
FROM Authors
WHERE [firstname] & " " & [lastname] LIKE '%#indexsearch#%'

at the moment all i get is

Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1

Any help would be most welcome :-)

Thanks

Craig.