Access 2003 and Word 2003 mail merge problem

[megabyte214]

I have some Access queries that I am using with Word Mail Merge. All the queries work great with mail merge except for the ones where there is a “*”. When I change the “*” to a “%” the mail merge then works, but then the query will not run in Access.

For example:

This does not work with Access, but works in Word mail merge:

…WHERE ((([Students].StudentID) Like "%1"))

This works with Access, but does not work in Word mail merge:

…WHERE ((([Students].StudentID) Like "*1"))

I am trying to figure out a way that the same query will run in both Access and Word without making two copies of the query (which I am currently doing)

Thanks in advance for any suggestions.