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
FROM newmail
WHERE file_no like [#file_no#*]
ORDER BY newmail.sorter, newmail.letter_date;

Please help.

Mateen

if your are using a text field you must evaluate
Place something like this in your query criteria grid
Like eval("InPutbox"(""Enter File_No:"",""newmail"")&"*"

This will prompt you with an input box " Enter file_no" if the user's input is null then query criteria will be like "like*" and will display all records.

or something like this:

LIKE "*" & [Enter Characters to Search by: ] & "*"


I hope this helps

thanks for response.

LIKE "*" & [Enter Characters to Search by: ] & "*"

it is working.

Mateen