I am creating an access report with a form that you enter a file name and that gets pulled into the query criteria so the report can search by the specific file name.
Criteria [Forms]![Enter File Name]![file_name]
I need to add in begins with to this criteria so they do not have to type the document extension PDF or DOC for example but I am not sure what the proper syntax is to get that to work. I know you can do like "X*" but how do you insert that into [Forms]![Enter File Name]![file_name]