Some querries not showing in Word Mailmerge

[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

 

[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]

 

[Jeff]

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

 

[Van T. Dinh]

IIRC, this is related to the problem described in the Microsoft Knowledge
Base article:

http://support.microsoft.com/?id=833064

There are some work-arounds in the above article you may want to try ...

 

[PROVA DE APTIDÃO]

I NEED A BIBLIOGRAFY OF A BOOK OF MICROSOFT ACCESS