Hello. I have a pivot query as source of a report
Here's what my issue is:
I have a specific field marked as Column Heading
So what I do is I select all the names from this field and put them as

I have a report that lists dues invoices and payments based on a query that
I'm trying to add a DSum function to at the end of the report.
The report has the following filter on it:
([Total_Amount_Paid] > 0 AND [Date_Paid] Between [Enter starting date:] AND

I have my report set up based on my form.  It has 4 tabs which don't always
contain data.  I would like to set it up to print the tabs that have data not
just the first tab or the tab showing at the time.  I also would like it to
show the tab name.  Can anyone help me?  Thanks in ...

I have a report where there are two CanGrow controls, ProbTitle and
Staff_Comments. I also have three boxes (Vote_A, _B, and _C) which need
to grow to match the height of the longer of the two CanGrow controls.
Here is my (non-working) code that I put in the Detail's OnFormat ...

(no answer)
We have a complex medical billing application that prints to a standard
medical HCFA billing form.  As there is no way to build the form into the
report, we are limited to having to realign all controls to individual

I want to add up to columns to show a total. ie I have one column with a
number and the second column with a number that changes as the user inputs
it, I want the third column to add up the frist two columns. Also where do I
do this in report view? or can I use table view?

Sometimes when I open my reports they open as the graph template instead of
my saved report graph, which is tied to a query. When I close and reopen it
seems to work fine, Any ideas?
Thanks

I have a report that has borders around the text boxes in
the report, color shading the header section that lists
the column names and a logo.  I am trying to export this
using Rich Text Format, Text Format, Excel or html but it

When I attempt to update my report I get the error #NAME?. Is there
anything wrong with the expression below. I'm lost...
=[Total month to date Periphery Grind Kyon Query]![SumOfSumOfPieces]
Steve

Ha:
The report is great in itself but I'd sometimes want no
groups that's only of the detail sections for not to
bother the sorting because I have sorted it. So, the thing

Question: How to do I format a report to to suppress the trailing zero and
decimal point for numbers greater than 1 (eg, 22 not 22.) and to display
leading zero for
numbers less than 1 (eg, 0.1) in the same text box?  Access 97

Okay... i have a control which is set to CanGrow=Yes.  The control is a
concatination of two data fields.  I would like for the second line of
the control (when there is a second line) to indent 5 or so spaces (or
the built-in vb tab, whichever).

This sounds so trivial, but I have never got it to work.
I have scheduling database, in Access. I have a form with student Records on
it, and I want a report that (currently) prints the student schedule for all
students.

Hi, I'm having a problem with my report and I'm not too experienced in
Access. There are several subreports in the report. Everything is connected
by the primary key, which is a number used to identify each person in our
organization. I am trying to print up the information for ...

I need to send faxes and other reports to our vendors.  A number of phrases
appear in several different reports.  The choice of phrases is dependent on
things like whether an expiration date had passed or not, so I have
constructed a query with a calculated field containing a ...