Like function not working

[hwagner]

I have tryed to get access to search my description field for a certian word or even letter and I cant seem to get any results at all. And if I do get anything it brings up all of the records not just the ones im looking for. Can anyone please help me.

Here is the quiry I am trying to run.

SELECT *
FROM indust
WHERE indust.DESC like '%fold%';

When I run this no records are selected, and I know there are several rows with the word fold in it.

 

[lupins46]

Access uses * not % (unless you are writing ADO code)

 

[hwagner]

Thank you sooo much. I tryed to find it on the internet and all i could find was the %.