[AccessD] Mailmerge not recognizing user defined function in Access 97 quer y

We have just switched over to Office XP but still have Access 97.   I am
having problems with a mailmerge from Access 97 to Word XP.  I have a query
with a user defined function that mailmerged with no problems to Word 97.
But with Word 2002 it does not even show the query if has the function in
it.  I have confirmed it is the function, because as soon as I remove it I
can see the query.  Word XP also does not recognize the format function but
it will recognize the dateadd function.

Is there anyway to have a user-defined function in an Access 97 query and
have Word XP recognize that the query even exits.

Christian Brock

P.S. Word XP is not recognizing the linked tables in the access 97 database
either.