i'm trying to make an iif formula for a report that if the student is from
monsey it should say "as you are living near to our premises" and if not it
should say "as you aren't living near to our premises"
I tried this but it didn't work

On the following thread, I have the same problem as the last post - the date
range shows up on my report header, but I have to enter the date range twice
- assuming once is for the query, and once is for the expression in the
report.  Is there any way to capture the dates from ...

I have a report with unbound columns calculating summary information and a
subreport with a snake column displaying records (both in the report footer).
The subreport works great when opened on it's own, but when I embed it into
another report and open that report, it doesn't ...

I have an A 2000 database with a unique report.  Each time the report is
run, it only displays data from one record in the table.  It has dozens of
uniquely named fields, placed in a vertical column, in the detail area.
When the value in a field is zero, I would like to eliminate ...

I am attepmting to build a report from two tables, 1. Client Info 2.
Appointments. I would like to creat a report that shows various appointment
dates in a calendar type format. The calandar must show a six week range, the
beginnning date for the six week range will be based on ...

I have a question requarding a form letter that I am creating for one of my
customers. It is a gratitude letter thanking a particular person on a
donation that they have made. The problem I am experienceing is the amount
that is being refereced will not display as a dollar value ...

I have a section in my report that comes from a list of products and their
prices.  The names of the products and prices do not take up much space
horizontally on my report but there are usually 15-20 of them which means
they take up space vertically.  I am trying to save space ...

I have a working report based on a query that asks for a few parameter
values to restrict the report.  What I would like is to show this value
in the report after it is created.
Any suggestions on how to reference this value or query criteria?

We have moved to Office 2003 and cannot print file path at 'Page Footer'.
Previously =[currentDB].[name] and =[name] have provided enough information
for report retrieval but now only =[name] works.

I would like to print a report to a PostScript file.
This is easy enough to do, but I want more.
I want to specify the output file name programatically so my users don't see
the dialogue box asking for a file location.

I want to be able to preview a report regardless of whether it has data or
not, but when there is not data, instead of returning #ERROR, I would like
to just show 0's.
Thanks!

I want to save 9 reports simultaneously as static HTML. Is there a way
to do this as opposed to opening each report and saving it individually.
Thanks in advance
CHW

I have 4-5 reports which require the same kind of criteria. I have one form
which feeds criteria to one of these and then produces the report. How can I
make the form dynamic enough to be able to select a report, feed the criteria
and then produce any one of these reports.

I wish to create a carried forward type report in Access.  Let me explain
what I mean by carried forward.
I have a transaction table, and every month, I want to print a report
showing the opening balance of the transactions up to the beginning of the

I am creating a report that has a text box based on a memo field.  This
field contains text that can vary in length from one sentance to a paragraph.
I set the property of this text box to "Can Grow" = Yes because of this.  
Below this I have a label that has some fixed text in ...