Using Access 2000, I have several reports that look great on the screen.  
When I send them to the printer, "List7:" and "List13" appears in many of the
boxes on the report. If I send it to Acrobat, the resulting pdf file does not
have the problem.

I can't figure out how to insert teh filename as part of
the footer on each page of my report,
which will update when the filename changes.
My purpose is to include the Revision letter of the

I have a report that needs a control from a different report, so that I can
give an overall total. Is there anyway to creat a text control and bind it to
a different report.
Anything would be helpful

Is there a way to link the tittle and axis label fields of
a chart object to controls on a form?
Is there a way to change a chart record source from
controls on a form? For example: Can I pick number vs

Have a Parent report with an embedded subreport
Parent report  is sorted by CeilingGroup and then Service
Service data is in the Service Header
CeilingGroup is subtotaled in the CeilingGroup Footer

I set up a 3 column report in the page setup. The data were printed ok, but
only the first column had deading. How can I make the heading on the other
two columns?
In the report design view, I only had one column with the heading on the

I have made a form with five multiselect list box's. Based off of the choices
a visual basic procedure builds a select query. The choices are Reactor Name,
Year, System, Task, and room number. It is a database to store radiation dose
readings for multiple power plants, years, etc ...

Example:  [Attendees] field returns 5 names.  I want to display these names
in sequence, divided by commas, on a report.

I have an Access 2000 report for which I want to include a conditional OLE
object (Word text block), and am having a difficult time with it.
In its simplest form, I want to place a field on the report, and based on
that field display a block of text contained in an OLE control. I've ...

I have a report lising case information.  I am listing the case#, SS#,
finding, Element#'s (which are: 10, 11, 12, 13, 14) for each case.  I have
findings of Correct, Discrepancy, Error and Drop.  What I want to do is, that
if the case is Correct, I don't want to list the ...

I have several reports that look great on screen. When I print them, many of
the boxes on the reports contain "List7:" or "List13". If I print them to
Adobe Acrobat, the resulting pdf file does not have this problem.
Any ideas?

I want the report to display only one record per page.  How do I do that?
TIA
Mike

I am trying to count different types of errors in a Report Footer: Correct,
Discrepancy, Error, Drop.  I used the =Count(*) to get the total records, but
need to get a count of them separately.
Thanks.

Access 97
I want to suppress 1 line of print in a group heading if there is no
data in the line.
The group has 3 textbox controls each print as a seperate line. I want

I am using a DLookup Function on my reports.  It works fine until I add my
criteria.  I need it by Agent.  Right now I have:
=DLookUp("SumOfACD Calls Received","Agent Setter ACD Calls Query","Agent
Name = ' " & [Agent Name] & " ' ")