I want my report to show the total sum depending in the category. The
categories are Lodging, Meals, Auto, Bus. This is how my report looks
like:
Date        Description     Category    Account #    Amount

Mdb file is shared  by multiple user's.Some of them when trying to run report
geting message:"Run-time error.The OpenReport action was cancelled".
Mdb file was just converted from Access 97 to Acees 2003.

Hai,
i want record number in access report. how to insert record number in access report.
thanks in advance.
regards

How do I display the total number of records listed on a report, inside a
textbox (control source) at the report footer level?

Hi. I am using Access 2003.  My main table (tblAnalysis) has a one-to-one
relationship with tblHazard through the AnalysisID. There are 78 fields in
tblHazard including number fields HazardID and AnalysisID, and checkbox
fields A, B, C, etc. on up to FF and text fields AText, ...

Is there a way using code to get the height of the Page Header to grow to
accomodate a field in the Page Header set to "Can Grow"?  In other words, how
can I trick the Page Header into growing and shrinking based upon the
contents height?

Hi i have a chart and i want to be able to change the order on the (y) axis
this is the query it is based on
PARAMETERS [forms]![filters]![txtcboXsecone] Integer, [forms]![filters]!
[txtcboxsectwo] integer;

How may I limit a report to on page length?

This report shows total expenses over a selected period of time. A couple of
groups will list transactions with accompanying dates. Since there are
several dates listed in a given month, and several months involved, is there
any way to come up with an avg per month in the ...

I need to create a report that gives all of the assignments and grades for a
single student in a single class.  The Results by Student report that came in
the template will give the results for all of the students, which doesn't
really help me.  I'm new to Access, and I can't ...

I am trying to print multiple labels from a query. For sum I may want 3
others 4. I want to be able to enter an item number (this is an autonumber in
a table) and the number of labels I want then move to the next item number
etc.

Help!
Running Access 2003.  When I print a multi-page report the 1st page prints
fine, but the 2nd page loses columnar format; then the 3rd page prints okay,
but the 4th page again loses columnar format.

My database has a listing of customers.  Some of my customers are people some
are businesses.  I have the "addressee" part of my form letter working, but
when I try to get the Dear ______, done, how would I get the letter to
recognize that if the [Attention] is blank, to use the ...

I have a report which is based on a query named Members which has a field
named Exp1:. I want the report to only show records in which Expr1: starts
with the letters A-F. I tried to add the expression below to the filter field
of the report properties. I get a syntax error when I ...

I have a text box on report whose control source is the Now() function and
the format property is mmmm dd", " yyyy.
I want the date to appear in capital letters on the report.  I have tried
the UCase function and could not get it to work.  I could not use the ">" in