My subreport recognizes only the first record of it's datasource when
included in the main report. Both reports work ok separately. I placed the
subreport in the report footer of the main report and the link masterfield
and link childfield propeties are set.

Using Access 2000 on Windows XP Professional.
I have a Movie db with .rle posters for each movie. It was working fine, but
nnow when I try to insert a poster for new movies I get this message "The
Operation on the OLE object failed - The OLE Server may not be registered -

Since my reports take a while to generate, I would like to run a macro to
save my report as an RTF file so I can have the macro run at night when I'm
not there. Is there a way to do this? (I know how to put the macros in the
task scheduler, but I don't know how to have the macro ...

I have a report that list the balancedue.  The balancedue is calculated from
the total due - paymentstotals on the main form.  After a payment is posted,
a receipt is printed and if a balancedue exist, the balancedue letter is
generated.

I'm sorry if this has already been addressed.  I'm a newbie, soon to graduate
to beginner.  I am making a columnar report, following the directions I found
for making labels on the left.  It worked!!  I was very surprised!  My
problem is that I want to have 12 columns on one page ...

Hi everyone,
I'd like to output a report that has several Queries as record sources to a
RTF file. I have a form that has a TextBox on it to let the user choose the
option (Query). The codes in the Click event of a CmdButton look like:

good day all...
  I have a report (rptpaymenthistory) that I run from my invoincing form.
The report has a main report and subreport that pulls data from a
tlbinvoicepayments.

have report that has like 25+ fields that i need to print out over 2-3 pages.
i would like to have the following fields to repeat on each page. any help
would be appreciated. thanks
Date, Check #, Account Name & Subtotal

When I want to print a blank copy of a Report so that I may fill it out
manually, I get a #Error on the text box that was expecting a value.
This is the procedure I have for this text box "Text55":
=Trim([CLFirst] & "  " & [CLInitial] & "  " & [CLLast])

In my sub report I just list names of people, in two columns. I use the
zigzag approach because I can't seem to get the down and up approach to work
(Access 2003). My question is, how can I print the number of people in the
subreport...preferable at the bottom of the list ...

I built a report that relies on a query "SalesByDepartment". I built an
identical report which relies on a query called "SalesByBusinessUnit. I also
created an option group on a form, so that when you choose Department, it
will print the department report and if you choose ...

In my report I need to total my DateDiff field (=DateDiff("d",[Date
Rejected],[Date Completed]) in the header.  It is a number of days, but when
I try =Sum([DateDiff("d",[Date Rejected],[Date Completed])]) the expression
is too complicated.  How can I get my report to total all ...

I have to write a report that will add on 10% to each line for the first 250
records and then 5% for the remainder of the report.
I have managed to cobble something together using VB code against the report
but wondered whether there was a better way.

I've created a report with a query.   Everything  comes in fine except the
2nd column of my report comes out with the same data as in the first column.  
How can I get it so it continues with the next page data.
For ex.  This is what it was doing:

The above access file has been in use for 5 or 6 years. It is saved on a
network drive that is accessable by any user. All users have complete access
to all features of the file. One user who has been using this file for some
time is unable to use any part of the existing ...