Getting Error 3075

[boywonder]

What I'm I doing wrong??? Keep getting:

Run-time error '3075':
Syntax error (missing operator) in query expression
'(((transactions.maker)= Returned Fee AND transactions.viod=0))'.

Following is the code I'm trying to run:

RCF = "Returned Fee"

Set rsQry = db.OpenRecordset("SELECT transactions.custno, transactions.NAME, " _
& "transactions.[check amount] , transactions.maker, transactions.[check number], " _
& "transactions.returned, transactions.[returned date],transactions.BALANCE, transactions.viod " _


& "FROM transactions WHERE (((transactions.maker)= " & RCF & " AND " _
& "transactions.viod=0));")

[pbaldy]

What data type is maker in the table? I suspect it's numeric, or you'd get a different error. If it really is text, then

& "FROM transactions WHERE (((transactions.maker)= '" & RCF & "' AND " _

[boywonder]

Yeah, it is text.

[boywonder]

That is it. My mine been in many place this Monday day. Thanks.

[pbaldy]

No problemo!