http://www.adopenstatic.com/faq/80040e10.asp Cheers Ken : -----Original Message----- : From: thelist-bounces at lists.evolt.org [mailto:thelist- : bounces at lists.evolt.org] On Behalf Of Adrian Gonzales : Sent: Saturday, 12 March 2005 7:28 PM : To: thelist at lists.evolt.org : Subject: [thelist] Access SQL Join and WHERE Clauses : : I'm usually developing with MySQL, but now I've got to do something on : Access. My problem is I cant get a JOIN and a WHERE clause to work in : the same statement. : : Heres my query: : FROM contacts : LEFT JOIN points ON contacts.cid = points.powner : WHERE contacts.fname LIKE '%#arguments.search#%'; : : And that throws the error: Too few parameters. Expected 1. : : What am I doing wrong. I'm sure I'm just being stupid. : : Thanks in advance.