I am having a problem with a Subreport in that if there is no dat
returned in the main report, the subreport does not run, even if ther
is data in the report. Probably something really simple I am doin
wrong. Can anyone please help?

I am working on a database that assigns a risk rating to an activity.  I want
the rating to convert into an insurance coverage requirement.  The following
is my expression.  What am I doing wrong?
=IIf([AUTOMOBILE LIABILITY RISK RATING NUMERIC]<=3,500000) Or

After converting from access 97 to access 2000 when I try to open some of my
reports from code I get an 'Enter Parameter Value' dialog appearing. There is
no field name listed in the dialog and when I press the OK button the reports
appears just as in Access 97. Is there any way ...

I have a report with an embedded chart generated from a  97K database on a
network.  Report format generated on workstation "A" consistently appears to
"clip" the last 4 dates of the chart.  The workstation "B" the report
formatting shows all dates available.  I can't figure out ...

I have an invoice report that is created in a batch. The qeury behind the
report gets the incoicenr from the batch.
Now I want to create a functionality to print a copy of the invoice. So I
created a form, with a text box for an invoicenr. I created a new report that

Duane Hookom was helping me and I thought I had gotten it right, but for
some reason, I now get a error when I use the following
="GER      "+[DestGER]. This is a text box that relates the to the check box
named "DestGER" I get an error #ERROR all the time regardless of the value

My report, with subform does'nt work in Access 2003 but does in 1997,why?

I just learned from a help article how to use DLookUp to get a value from a
field in a previous record.  That value will be used in 2 or 3 computations.  
I found that I could get that function to work in a table designed for my
car's gasoline consumption.

I have a database which allows the user to print an envelope for the
selected record.
In addition, the user can select from one of two different envelope sizes.
My problem arises from the users default printer. How can I design the

I havea database that generates a report with a variable number of pages.
Sometimes the last page (which is configured to be in the report footer of
the whole report) has no data to be printed. But usually there is
information to be printed.

I ahve database with report that includes list of projects along with %
complete column.  I would like reprot to only show projects less than 100%
complete.  How do I do this?

I have a MainReport with a SubReport1.
SubReport1 has a SubReport2.
The report is perfect and looks nice.  However, when I Preview the report,
the screen "flickers" six times, with the outline of a blank report.

I am linking MS Access 2003 to SQL Server 2000.  I am trying to display a one
to many set of images to a single set of data.  In SQL Server I have the
objects set as data type Image.  In MS Access I have a sub-report with one
control on it, Bound Object Frame.

I have a report that shows only a 15-column chart. Coincidentally, there are
15 pages of the chart. How can I display and print only 1 page?

I have 6 fields on my report and would like to draw column lines that are
capable of growing depending on the detail data with the report. I have done
some research on this board and realize that line method might be the answer
but I am not sure how I get the lines to align up ...