Print a list of reports

What version of Access are you using.

You can try using a query against the access system tables to get the report
names. You can then use this as the record source for your report. The SQL
statement below will list all the report names.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

jean wrote:
Hi

I have in my database over 90 reports and I would like to print a list
of them

I have check with the documenter but it seams to print one page for
each report

I have play with options without result

Is it possible to have a list of report that can fit let say on 2
pages instead of 90

thanks

Hi

I have in my database over 90 reports and I would like to print a list
of them

I have check with the documenter but it seams to print one page for
each report

I have play with options without result

Is it possible to have a list of report that can fit let say on 2
pages instead of 90

thanks

This query should give you a list of reports:
SELECT [Name] FROM MsysObjects
WHERE (([Type] = -32764) AND ([Name] Not Like "~*")
AND ([Name] Not Like "MSys*"))
ORDER BY [Name];

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"jean" wrote in message
...
Hi

I have in my database over 90 reports and I would like to print a list
of them

I have check with the documenter but it seams to print one page for
each report

I have play with options without result

Is it possible to have a list of report that can fit let say on 2
pages instead of 90

thanks