SQL Query

[CrazyCanuck]

I have a form used for searching where I create an sql query.
It talks to my query (QrySearchall)

ex:
sCriteria = sCriteria & " AND qrySearchall.customer complaint like ""*" & txtSearchInput & "*"""

The problem is (as seen above), some of my columns are 2 words (customer complaint). One word columns such as "date" or "line" work fine. How can I adjust the sql syntax so that a 2 word query column can work?

 

[pbaldy]

qrySearchall.[customer complaint]

but you should really avoid using spaces.