Question i got error on my access query with replace([Items.Des]," ","")

[E_Gold]

i got error on my access query

SELECT CounterG.barcode, CounterG.qty, CounterG.Des, Items.barcode, Items.numH, Items.Des

FROM Items INNER JOIN CounterG ON replace([Items.Des]," ","") = replace([CounterG.Des]," ","") ;

i got error on: replace([Items.Des]," ","")

how to fix it ?

 

[pbaldy]

Re: i got error on my access query with replace([Items.Des]," ","")

Have you tried without the brackets? They're telling Access that the whole thing is a single field name rather than a table/field.