Import Access report into a Word document, not as rtf

[Guest]

I would like to export an Access 2003 report, with all its grouping formats,
into a word file as a table but not as a rich text file, rtf. The source of
the report is a query. I am able to import this query into Word "table
format" but without the grouping format, the result is a Word table with lots
of duplicate data in one of the fields. Can I create a query that will only
display data in groups?

 

[John Nurick]

Leaving the query question for the moment, have you tried exporting the
report to HTML format and then opening the resulting document with Word
2003?

As for your specific question, the answer is "up to a point". Here's an
example of a query that omits the value of a field if it is the same as
in the previous record:

SELECT
IIF(A.ID = (SELECT MIN(B.ID) FROM Judy AS B
WHERE B.EmpName = A.EmpName),
A.EmpName,
NULL) As fEmpName,
A.Score,
A.ID
FROM Judy AS A
ORDER BY A.EmpName, A.ID
;

The table is Judy, the primary key is ID, and the "grouping" field is
EmpName.


On Fri, 2 Jun 2006 04:25:01 -0700, m horn <m