like clause in Access
how can use like clause in access ?
I use following query in access report, I want that when report run it ask the file_no and user
enter file_no then it display records which is like "AD" etc
I use following query in access report.
when query run and it ask file_no user enter AD930 then it display all records which related to AD930, but problem is that when user enter only AD it does not display records why ?
it should also display records which related to AD how ?
How can use * sign in the following that is display all records which is begining with AD and also AD930,AD931,AD932,..... etc.
SELECT newmail.outgoing_no, newmail.originator, newmail.actionee, newmail.letter_date, newmail.file_no, newmail.subject, newmail.filed_in, newmail.date_filed, newmail.to_from, newmail.incoming_no, newmail.sorter
WHERE file_no like [#file_no#*]
ORDER BY newmail.sorter, newmail.letter_date;