I have a main report with 3 subreports. I have 3 group headers and the 3
subreports are in the details section. The parent/child link is on DMSID for
all 3 subrpts.
I have run all of the queries used in the report and the 3 subrpts. They run

I have a report that displays students by grade level.  It calculates total
number of students by grade, but I need to get a grand total (for the the
whole school) in the report footer.  I've tried a few things, but I keep
getting an Error message...or counts the total number of ...

I have a subreport which I have finally succeeded in making into a two-column
report.  I want the end result to look like this:
NAME   DATE      NAME    DATE
1111    1111       2222     2222

Is this possible?

In my database I have defined fields to identify inactive records and records
that are siblings (duplicates).  When I print the labels, I do not want to
print labels for inactives or siblings.  How do I use those two fields to
exclude records when I print labels.  I must exclude ...

I need help in looking 20 fields and if the answer equals (whatever), look in
anothers fields and add them together.
Such as:
If (field) or (field) is equal to 101, then look in (these other fields) and

[Deliverable 2]<"Today"
Ihis correct format to compare date in Delierable 2 field to today's date?  
Doesn't seem to be working.

I've been wrestling with some simple charts in an Access report for a few
days now and have made great progress thanks to some help from this
discussion group. I now need to produce a report for about a dozen reps
showing a different chart for each rep. I've set up the chart on a ...

Whilst playing around with creating a bar chart, Access seems to have changed
the sequence in which my bars are being displayed. The underlying query shows
one sequence but the chart show another. Is there any way in which I can
change this display sequence?

I have a report that I need to sort.  Each loan in the database has 3 people
associated with it: Sr. Manager, Manager and Analyst.  I want to pull the
report and have it sort like the example below. Is this possible?
Smith

I have a report where I am using the DCount in the report footer in an
unbound control to count certain criteria in a field [Formal Discovery by
us:].
It worked for all of the answers in that field except for when "Other: "  is

I am not able to send photos like before.  Message appears that my MAPI is
enabled???

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0
...and seem to be bumping into a limit on the filename length?  (126 total

I am wanting to produce a report that is listed by category, but at the
moment this is what i get:
depot name
                    bus type

Duane:
I am modifying a sample report from the BRDemos database from your
website. I am working with the rptShipRequiredDates from an Access97
sample. I have adapted everything to my needs but have run into a