I have a report that has an [hours] field. I have a totals field in the
report footer that calculates the total hours for the whole report (about
1200 records), but I also need a subtotal for each page. The grand total in
the report footer works fine, but any calculation I put in ...

This database is the first time I've used the AutoNumber as my Primary Key
and I'm having many trials. As the Subject says "Three Questions."
1) I use a query to my reports. Sometimes, the FieldID AutoNumber, ie, “13,”
shows in the Report "Print Preview" rather than the entered ...

I have a report that I need to have the monthly totals and the YTD
totals on the same page. I have a query setup that the user enters the
dates for the monthly totals  but I do not know how to get the YTD
totals.

Hey all.
I am trying to create a report based on a crosstab query for a count.  I am
limiting the data based on a date range, being pulled in from a form which
generates the report.  

I have a calendar report which uses 30 copies of a sub-report to
build
each day. Working just fine except:
Let's say January 16th, there are 2 items to be listed for that date

I have a report that gives me a football roster.  One of the FIELDS in the
football players TABLE is for DROPPED OUT children (Yes/No).  How do I tell
the football roster report to leave OFF the children names that have dropped
out (i.e. there's a checkmark in the yes/no box for ...

I have a report of comments on particular topics.  The report looks at the
comments related to a particular topic
Private Sub Command10Preview_Comments_Click()
On Error GoTo Err_Command10Preview_Comments_Click

I have main and sub report , transferno field link between them. My report
can print only first page but it does not print data in sub report on page
2,3.... .. My report has no special group header.r

Please forgive the repost of the same topic, but I really need to get a
table of content report and keep getting error msg "Type Mismatch" for the
OnPrint function.  I have followed the instruction from the Ms Article for
creating a table of contents in both the Northwind db and ...

Access 2007 will not save printer information for any other printer except
the default.  As a result all reports go only to the default printer.  In
past versions of access in page setup you could change printer setup for a
specific report and save it with the report.  This is ...

I am creating a report that is a class roster listing information about the
parents of students in a school's classes.
The underlying table contains information about the students' parents.  Each
student may have one or both parents and each parent may or may not have, for

Hello! I'm hoping the discussion group can advise me on a couple of
formatting issues-
I have a State field that is 2 characters with a format of " >". Great for
data entry, but when the State in pulled into a report, the State does not

Hi I'm using the demo ordering system and have copied the invoice report and
have got it to run for all records. But now i want to exclude records that do
not have an outstanding amount. eg Total Due > 0 As this is a calculated
field within the report i dont seem to be able to ...

I have done some reading on this and want to get on the right track with the
way I am storing data in my tables. I have been working on a database which
contains a form with 2 combo boxes one dependent on the other. The first is
using a table which contains a "BusinessID" field ...

I have Bar Chart in access database.
Rowsource for this chart is
TRANSFORM Sum(Chart_FD.CountOfUCCID) AS SumOfCountOfUCCID
SELECT Year