I have a section that contains labels with IsNull statements.  So if no values are there they should not appear.  Well they don't appear but a page prints anyways.  Does just the fact that they are encoded in there cause it to print?  Is there anyway to create some type of NoData ...

This is the scenario during my testing:
Scenario A : I preview a report based on a selection criteria Bank A &
Location 1, and then I close it.
Scenario B : Next (after Scenario A), I select Bank A & Location 2 and click

       Is there a simple way to make the total for a section stay with the
last deatail?  In other words, if the total for a section has to go on the
next page, I want the last detail to go there as well, so it isn't so
isolated.

Can anyone indicate a way to retrieve the actual content
of the field name rather than the value within the field,
i.e., if a field is [NAME1] i want to retrieve the
value "NAME1" and not whatever is in the contents of the

I have a report that contains several subreports. I also simulate a
watermark on the report by setting the report's Picture property to an image
file. This all works pretty well, except for one of the subreports. This
subreport uses conditional formatting to bold some of the ...

In the underlying query of my report I have fields for
Group, Trait 1, Trait 2 and Trait 3. My report displays
data so that there is one row for each record (Group)
as shown below.

There is something causing the first page of my report to print the page header and other pertinent headers with no detail section.  That makes the second page of the report what the first page should be.  I cannot find any controls tucked in anywhere that is causing this.  Is ...

Duane Hookom, the database I designed comes from your Survey database, it is
great.  I have added a few things, here is the sql from the crosstab query.
PARAMETERS Forms!fmnuReportSelect!cboSrvID Long;
TRANSFORM Count(tblResponses.Rspns) AS CountOfRspns

Help!
I can't remember how to show a field only once when that field appears
multiple times in the query.
Specifically, I'm preparing a report showing the streets within a

I have arranged about 40 calculated text boxes within the dimensions of a 1
page report.  It all fits within the boundaries of a single page but I get 13
pages of the same information printed out.  It started out as 16 pages but I
did something that reduced it to 13 pages.  I do ...

I have designed a report with a subreport, based on two differnt queries
from two different tables. The main report  returns a record with data about
a single client. The subreport lists the last 10 orders received from that
client. Both the report and subreport are limited to ...

When I create an mde file, the user gets a restricted menu.  One of the items
that's left off is SendTo (email) in the Print Preview menu.
I can add a button and write code to do this, but it would be simpler if the
user just had SendTo on the menu.

I designed a database of my school's learners. I have designed a classlist
report, but it gives me all the learners in the school. How can I set it up
that it will only print specific classes (e.g. only Room 1A) . I know I can
do it through a query, but the I have to set up one ...

I don't see any facility in A2K to "drive"
envelope addressing, as we would with
label reports. It would seem to be a
common problem. Is there a way to

Can anyone help me with an approach on how to do this. I know I can select a
query and then use Export under the File menu, but I need to do this task
just by clicking an button. I know a little about access vb code so if
someone could give some hints on how to perform this kind of ...