Hi All~
I have a main report that contains 6 subreports.  Each subreport has a graph
in the detail section and information in the report header (which is needed
to clarify each graph).  If there is no data in the graph, I want to remove

How do I write an IIF statement if I want to exclude rows where there are
dates.  There are 3 date fields.  If one of the date fields is Not Blank then
do not print report.  If all fields are Null then print report.  Would a
simple "IsNull" in each field in my query suffice?

I have this problem when i print the report from access. After clicking on
the print, i have to go to the printer to press on the start button to print
but the problem does not appear on the other PCs as well as other microsoft
office product.

I have a few columns of data that i would like to graph for each customer. My
chart is coming up blank. I have a report that alreayd lists date, weight,
waist inches, and a few other items. When i add the date and the other values
(in expectation to see how the values change over ...

Any controls or ideas on doing an linked org chart other than placing text
boxes and lines in a report?

I'm hoping someone can help me with this.
First of all, i created a form with multiply text boxes with complex
calculations in each text box. When you move from one record to another
record, each text box will change  due to the calculation.

My report is emailed using the snapshot feature, but when a specific user
opens it, it's just an empty page. Others can open the report with snapshot
except this user.
I download the viewer from MS website and re-install it into that user's

Ok,
I know I'm going to get a bunch of links posted in this one regarding see
this post here and see this help section there, but I've looked at them and I
still can't get this to work, so here I am.

I am working on a program to print bills.  I designed a report with two
pages, the customer address on page one and the billing info on page two. I
then print it auto duplex in landscape and it works correctly. We then fold
it in half to be mailed like a postcard and the bill is ...

I am trying to change where the next record is displayed on a report.  For
example, if you had a list of months, it will display as follows:
Jan
Feb

Part of my code works, but recently I wanted to change more report
properties.  Access 2007 doesn't have a lot of explaination of the use
of properties.  This is my "change properties of all reports" code:
=================================

In Access 2003 one can view a report & click "Analyze this with Excel".  That
feature is no longer available in Access 2007.  Just exporting the query
behind the report loses the grouping and sorting feature that the report
provides.  Is there any way around this? It was a great ...

I have a report that needs to show the top 10 sales opportunities. I have it
setup and it works fine as long as there are actually 10 opportunities that
get returned from the query. The problem is that if only 5 opportunities
happen to exist, it only shows the 5 lines of ...

I will have 8 different main groups in my report.
I want to change the Text Box contents (Column Titles)as a function of
the Grouping. Thus I want to have 8 different sets of column titles
(consisting of approximately 12 columns)

Is it possible to format the pareto chart by sorting the maximun number show
in the bottom of each bar and ignore sort by Legend item?