I just can't figure out why this code is not working?  When I run the
subreport by itself it works fine. When I run the Main report I get "0" and I
know there is data in txtSumExpAmount on the subReport.
Main Report Textbox Control Name "txtFamTotal" control source is:

In a portrait layout report I have squeezed in the text boxes, adjusted the
margins, etc. but the problem of page width being exceeded doesn't go away
and an extra page is thrown as a result.  From what I can tell the page width
has not been exceeded.  

Here's the code:
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Dim rs As DAO.Recordset
 Set rs= CurrentDb.OpenRecordset("Select * From [MonthlyCash]",

The database was created in Access 2000, running on W2K Pro.  The grouped
report was sorted on 2 levels, the second of which turned out to be
incorrect.  I then opened the file in Access 2002 running on WinXP Pro and
re-did the second level sort.  I lost the first data item in ...

I have a form to enter help desk calls. We have one field with start time and
one with end time. Then we have a field to calculate the number of minutes
spent on each call. That field is called "Minutes".
In my monthly report,  we detail the month's calls. Then we want a total of ...

I feel like I have tried everything!
All I want to do is calculate a subtotal on a report, and then add up all
those totals for a grand total at the bottom.
My report contains: Quantity, Product, and ProductPrice

With DSUM,  the value seems to be calculated proper but shows up blank on the
report.
Here's the code:
Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)

My Query works correctly showing 52 items. The Report duplicates and
multiplies the contents of the Query, giving 2457 items or on another
occasion 741. What can I do?
Cheers, Paul

I have created a access database whose table consists of records with a
overtime data field containing hours and minutes (HH:MM).  I would like to
create a total field at the end of the report that will give me the total
over time for all records.

I se "Force New Page" = "After Section" . So that each group will be
started from a new page.
I want display something on each first page of every group. How to detect
that current page is the first page of a group?

Report Row has five (5) Variables: Contact, and Name_1, _2, _3, _4
How do I make only ONE of the Name_n Text Boxes Visible depending on the
Value of Contact (1, 2, 3, or 4)
i.e.: If Contact = 1 Then Me!Name_1.Visible = True; Me!Name_2.Visible =

On a different post, I was given a useful suggestion on using a Where
statement I store in a text box (see form and field name below) to open a
form.  I placed the following code on my form:
Me.Filter = strWhere

I am trying build a function, where a report can run, and is filtered by user
inputting a parameter in a inputbox.
This does not work; it still prompts for the parmater from the underlying
query

Printing invoices for multiple clients at same time.  Some client invoices
have more than one page, some only one.
Want to add page header to pages 2 through the end for EACH invoice showing
date, etc at top of page.  Can get this to work for one invoice, but

I've created a database for tracking change requests at my work.  Each
change request is given a sequential number.  I attempted to create a report
which would allow easy viewing of the most important pieces of info regarding
each request.  Now, my supervisor wants a summary at ...