Im trying to set up a report that will print out another report only when the
first report is blank.
I place a open report macro into the on no data event  of the first report
and get a runtime error of 2212 error when it trys to print the 2nd report

I'm working in a report with Microsoft Access 2002, based on a query. The BD
has another table with 2 fields: "Year" and "Quota of the year".
I need to put that "year" value in the page header and the "Quota" value in
the detail header.

I have report that I want to print in a booklet, each page being 1/4 of a
8x11 sheet of paper.  The report spans about 60 pages, so I'm looking at
putting multiple subreports in a main report.  However, when I do this, the
top 2 subreport will populate the entire page and the ...

When in Design View and a text box, a label box, or a line are selected (just
using those as examples), if I hold the "Windows Flag" key down pressing one
of the cursor keys, whatever I've selected moves one dot in the direction I
want.  If I hold the Cntr key down while pressing ...

Need help on printing the labels and values on a subreport even when none
exist.  I have subreports that I want to have print out even if there was no
data entered into the table.

I have a form in which one of a number of conditions is chosen for each
record using a combo box. Once a condition is set in each of the records, a
print button is clicked and a report is generated for each condition. Each
report contains all records in the form that meet the ...

Probably a very simple answer to this but I can't find it.  How do I suppress
zero (display as a blank) on a report.

A few times, the data under a section spans multiple pages (ie. a list of
contacts in a state).  I would like to have the section header (State Name)
repeated on the second page but with "cont." included (ie. Illinois cont.)  
Any suggestions

Access Version: 2003
OS: XP Pro
First a little info about the database. This database is used to keep track
of checkout information from our production department. It has three main

I'm creating a report and want to count the number of cells with currency in
the column called Downpay.  In my control source I'm using this criteria but
keep getting an error value, any ideas on how I can count these.  I don't
want a sum, I just want a count.  Thanks for your ...

Using AC2003 (2000 format)
I have a report based off of a query with the following seven fields:
PO Number, Description, Notes, Status, Date Entered, PO Created and Company
How would I make the bachgrounds of all seven fields red when the word

I have a button with code attached,  that once clicked will envoke the
following. I would prefer to view first prior to printing, as there are many
pages (10 reports). What would I add to this code to get it to work, or is it
possible?

I'd like to hide a line when a field from a query = a 0 or IS NULL.
Meaning:
Client_name Bill# Total
Joe Brown  123456    $1.500 (this line should appear)

Can anyone tell me if it is possible/how to set the sort order in a chart. It
is in alphabetical order at them moment abd i can't seem to change the order
at all, same with the legend which instead of Mar, Apr May puts it as Apr,
Mar, May?

How can I have a report utilize the results of multiple queries?
Thanks