Some querries not showing in Word Mailmerge

J

Jeff

Hi All

In my database I have various querries.
I want to be able to use the data in Word to print out automatically
reports of the test results for each student.

The problem is that the querry exists in Access and it works fine with
the other querries, forms and reports.It just doesn't show up when I
enter the database via Word Mailmerge to select the data origin querry.
Other querries are listed, but not the one i want to use.

Any ideas why?

Thanks

Jeff
 
J

John Vinson

Hi All

In my database I have various querries.
I want to be able to use the data in Word to print out automatically
reports of the test results for each student.

The problem is that the querry exists in Access and it works fine with
the other querries, forms and reports.It just doesn't show up when I
enter the database via Word Mailmerge to select the data origin querry.
Other querries are listed, but not the one i want to use.

Any ideas why?

If it's an Action query (Append, Delete, etc.) then it won't appear;
I'm not sure what the other restrictions might be. Could you perhaps
open the offending query in SQL view and post the SQL text here? Can
you see it opening in datasheet view?

John W. Vinson[MVP]
 
J

Jeff

John said:
If it's an Action query (Append, Delete, etc.) then it won't appear;
I'm not sure what the other restrictions might be. Could you perhaps
open the offending query in SQL view and post the SQL text here? Can
you see it opening in datasheet view?

John W. Vinson[MVP]


Thanks John

Here's the code from the querry. It opens ok as a querry. Maybe the
problem is that it prompts the user to choose which class to show the
list of students when they try to open the querry. That would be the
[Qual Turma] at the end of the WHERE instruction.

SELECT tbAlunos.Código, tbAlunos.Atívo, tbAlunos.Nome, tbAlunos.Título,
tbAlunos.DataNasc, tbAlunos.RG, tbAlunos.CIC, tbAlunos.Endereço,
tbAlunos.[Tel(casa)], tbAlunos.[Tel(trabalho)], tbAlunos.[Tel(celuara)],
tbAlunos.NomePai, tbAlunos.NomeMae, tbAlunos.Endereçopais,
tbAlunos.[Tel(Emerg)], tbAlunos.Colégio, tbAlunos.Empresa,
tbAlunos.Inglês, tbAlunos.CursoInglês, tbAlunos.Espanhol,
tbAlunos.CursoEspanhol, tbAlunos.CursosTerminados, tbAlunos.Obs,
tbAlunos.[CustoTotal Inglês], tbAlunos.Prest, tbAlunos.Mensalidade,
tbTurmas.[Turma ref], tbTurmas.[prof ref], tbTurmas.Livro,
tbTurmas.Dias, tbTurmas.Horas
FROM tbTurmas INNER JOIN tbAlunos ON tbTurmas.[Turma ref] =
tbAlunos.CursoInglês
WHERE (((tbAlunos.CursoInglês)=[Qual Turma])) OR
(((tbAlunos.CursoEspanhol)=[Qual Turma]));


I copied the querry and removed the WHERE instruction so that it shows
all the students. The user will have to filter the results using the
mailmerge facilities instead.

Thanks for your advice, it gave me the key to solving this problem.

Jeff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top