Where statement in Spreadsheet not working.

[jagjot]

hi i am opened access data in spreadsheet and after right clicking on data > edit query, i tried to change the query.
but something is weired, after where statement its not working.

SELECT johns.Responsibility, johns.[EED outlook Date], johns.[Form Number], johns.Completed, johns.[Code Name], johns.[Date CR recorded], johns.[Completion Date]
FROM johns
WHERE (((johns.Responsibility) Like "FRED*" Or (johns.Responsibility) Like "S SMITHER*") AND ((johns.Completed) Like "PENDING*"))
ORDER BY johns.[EED outlook Date];

Thanks in advance..

 

[jagjot]

it worked i changed * with %