i need to repeat the grouping names so i moved those fields into the page
header section.  The header does not show the proper group until the second
page of that group. thanks for any help.

I am creating a report that shows the winning bidders for a silent auction -
some of whom may be buying more than one item.
I have figured out how to create the report that creates a separate page for
each bidder, however it shows only one auction item per page. How do I get

Hi, I've created a main report with two sub reports which work OK except that
where there are no sub-reports associated with a record, it will not ignore
that record and prints it along with a blank space where the sub-reports
would be.

When using the Send attachment funtion in Access, it works however, the
formatting of the report does not remain. It does not matter how it is sent
over ( rtf, html etc...
Any one know how to keep the formatting?

At the end of certain reports, I want to print out on a new page some
standard text,which i have defined ion a second report.
on the first report I have dragged the second report onto the first report
footer and set the properties to new page before section - but this does not

I have an Access 97 database.  When I run it from one pc, it generates the
report with the correct header/footer/margins.  When I run the same report on
another pc, also with Access 97, the columns are all skewed, dropping to the
next line, wrapping, etc.  I have ensured that ...

Knowledge Base article 839779 refers to the problem, but there is no
solution.  Does anyone have a suggestion how to get around this?

When I view my graph (report) in design view the data shown on the graph and
in the datasheet in not my data and appears to be from the defalt chartwizard
database.  How can I view my data so I can manipulate it?  I've tried viewing
it in print preview and it shows my graph but ...

I want to filter a report between dates. I'm using an approach suggested
from a ng search, where I create a simple unbound form to enter the dates.
The dates are referenced in a query criteria field, and the report is based
upon the query.

I have a record with several fields.  Two of which are named "Comment" and
"Clinic":
I have a query with criteria in the "Clinic" field of  <> "PROM":
If I leave the "Comment" field blank,  I don't get all the records to

I have a report "A", which has report "B" as a subreport ( it is in the
Report Footer of report"A".
Report "A" prints on headed paper, but we have a graphic that we want to
appear on each page of Report "B".  i have inserted the graphic in the Page

We are experiencing issues with reports set-up as landscape reports, but
sometimes printing Portrait (most users have the issue the first time they
print after starting the database)
We are using msAccess 2003 (SP1) on Windows XP machines.

My report has a number of subreports that are stacked vertically. I have can
grow/shrink set to yes for all of them. Of course, if I have many records in
a subreport it grows and interferes with the report below it. Is there a way
to make the subreports move further down in the ...

I have a report which includes 3 sub reports, each with a total.  I have then
added these 3 totals to give a grand total.  However, if one of the sub
reports have a zero total, the report total comes up as an error. Is there a
way to stop this happening?

How can I put a page number (page..of pages...) on the report footer for
each group, in the way that when each group starts on a new page, the page
number starts from 1?
--