I try to create report (ReportCollection) from 3 tables:
  1. tblCollections (has 16 fields)
  2. tblAgent (has 6 fields)
  3. tblNotes (has 23 fields)

I'm sure this is simple, but can't think how to do this.  I have a report
that prints out a list of student names, student id's and awards.  There are
multiple
records (students) with the same last name, but they are in fact different

I created a report from a simple query.  From the report how do I create a On
Open Event = Run query, so that I don't have to click on the query and run
each time to refresh my report.
Beginner in Access and cannot find the steps to accomplish this.

If I select a date from a drop down menu, I would like that to be in
the title of the report that generates.Is this possible without having
to create a report for each date that exists in the list? Thanks in
advance.

Access 2007
I have a report with a header section which I have set to repeating so that
it appears on each page.
Is there a way of adding the words "Continued" to the header section when it

I would like to know the best way to create 1 summary page in a report that I
can manipulate all my data from the entire database. I've tried bringing the
information in the Detail part of the report and hiding it, then using Totals
in the Footer Section. I ended up with 50+ ...

I want to create a report based on two tables.  The first table is called
"AuditSubSection" and includes the fields AUDITSUBSECTION, AUDITSECTION,
INLCUDE IN REPORT, & FINDINGS.  The first three fields are text and the last
two are Yes/No fields.

I have a report that has the following
Phase1_Date, Phase2_Date, Phase3_Date, Phase4_Date, Phase5_Date
Phase1_ComplDate, Phase2_ComplDate, etc.
How do i get the report to color the Phase1_ComplDate using if then

I have created a report (using Design mode) that gets values from various
queries. For each report it shows kind of Course Title at the top. I have
tried to export it to Excel or even RTF and the exporting completes but there
is nothing inside these files when I open them.

I am attempting to open a report with more than one where condition
and I am getting a Type Mismatch error.  I can't figure out quite how
to get this to work.
Private Sub cmdOK_Click()

I need a report that will display the date of each Saturday between two
dates that are entered into two (unbound) controls on a form (they are
called 'datefrom' and 'dateto'). Each Saturday date needs to be on a new
line - as if each one was in fact a record in a table. The only way ...

I am having a difficult time applying a filter to a Report.  What I have is a
Report that's control source is a Query with several fields on the Report.
One of the fields is named JobFunction and that is the field I want to apply
the filter too.

I need to generate about 100 bar charts by a division.  Can anyone tell me if
this is possible to do in Access?  I can generate one but it doesn't seem to
be breaking and generating the others.

I have a report and I have a table with Names, when I run the report I want
the user to select a name to print from on the report in a field that I set.  
How would I go about setting this up.  Thanks for your help.

Using Access 2003 sp1, I have created a small form which allows the user to
select a date range to filter a report.
I've got the dates (along with all the data) to appear correctly in the
report preview, but when printed out, the date shows as #name?