Word/.mdb mail merge - missing queries
-
Got a question for all you Office programming gurus. I've got an Access 2002 .mdb database I've been working on (Access 2000 file format) to store a variety of data (customers, job/orders, products, vendors, salespeople), and I'm trying to set up a mail merge with Word. When I open the data source in Word 2002, only 7 of my 16 queries show up in the dialog box - the others are missing. When I open the same .mdb file as a mail merge data source in Word 97, all the queries are there, and the one in particular that I'm trying to use that is missing in Word 2002 works just fine in Word 97. None of these queries are doing anything too exotic - all just select queries with various joins - a few have criteria based on form controls, but I'm not worried about those. A couple are joining tables with other queries, but most are just joining tables. Any ideas what's going on here? I'd rather not post the actual database in question, but I'm running out of ideas. Jeff Sand jsand42 at earthlink dot net