Query doesn't show up in mail merge (Office 2007)

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

We have many queries in a database. They are all very simple. Some don't
show up when doing a mail merge. Please help!
 
Hi Janet,

It depends on the contents of the query. Parameter queries may not
show up, of if they do, they may fail because the use of parameters is an
Access extention to SQL. Likewise queries that reference fields on forms.
Or that reference VBA functions such as Nz() or custom functions that you
write. To deal with parameter queries, use an underlying parameter table.
So you would have the user enter the parameters into a form in Access that
then saves them into the parameters table. Then you would make the query
join to/use the parameters table to in lieu of requesting parameters. If
after this information, there is a particular query that you are wondering
about, post it and other pertinant information about the table(s) it uses.

Clifford Bass
 
Thanks for at least giving me something to look for. I'll do that when I get
back to work Tuesday.
 
I have the same problem.

It's a very simple query -- no parameters or custom functions. I actually
copied a query and just changed the criteria. The original query shows up,
but the copy does not.
 
Back
Top