I want to create reports as per users selections. I want to be able to do
text searches across multiple fields (some are drop down andother are check
boxes)  so that I can pick and choose the criteria for a report. Essentially,
I would like to perform searches on multiple fields ...

Is their any way to display a zero instead of #Error?

I have a report with a sub report in it. Both the report
and the sub report ask for the same parameters due to the
queries they were built off of. The information that for
the parameter is a start date and and end date. When I

I am using Access 2000.
I want to calculate parallelism of a surface by collecting 4 different depth
measurements. I would like to subtract the smallest of the 4 readings from
the largest of the 4 readings. In the Access report, I would use a 5th column

I created a query to pull specific records from a table; ie. those records
with contact dates in the month of november were extracted from four choices
of contact date fields.  Now I want to be able to put in the report not only
the client data, but the specific date in Nov which ...

in Excel you can use the MOD() function...  Need this pretty quick!

Is there a method for alerting the user that Legal Size Sheets will be needed
to run a particular report, and have it be report specific. In other words if
one report is 8.5 X 11 leave it as is, if it's 8.5 X 14 flag it and generate
a pop-up to alert to user to use Legal Size ...

Some time ago I came across a sample access database that would convert
numbers too text and actually print out cheques.
Have searched extensively the microsoft site but without success. Could
anyone point me in the right direction, as to download.

Hi. Is it possible to have some ON Print code in a
Reports Header section that makes a Subreport visable
only if certain other criteria are met?
For example, say I have fields txtSubject and txtYear in

I created a chart and look good on my screen.  I was able to print the
chart.    When I send a database to my friend and they open the chart and
doesn't look right and some information cut in half.   We use Legal size and
landscape.

When I open one report I want to check to
see if another report is open.  If it is not open
I want to open it.  The following is my attempt
at the code.  Could someone help me get it?

I have a temp table that gets built each time a report is run to use as the
record source of a chart on another unbound report.  The table contains
char(),int,int datatypes and the record source for the chart select the
char() & int and sorts (but does not include) the 2nd int ...

Hey all,
I have a report based on two tables.  Prospects has sales information
that includes a salesman and a final sale total. Activities has
multiple records that relate to all activities required to make the

I have a field will a short list of allowable values (from a table).  My
user wants the output of the field's contents to show as though a radio
button were selected from the allowable choices.
E.g., if my field's allowable values are "Red", "White" and "Blue", and the

Here is an error that we get for a report:
This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated
elements.Try simplifying the expression by assigning parts of the expression