I have a table ex:
ID    Fund     Percent
A       101        50
A       102        50

I am using the following statements, but they return nothing (blank), when
they should be returning -18.96
=IIf([BillingTotal] = < 0,"Val",[BillingTotal])
=IIf(Val([BillingGST]-[BillingQST])<0,Val([BillingGST]-[BillingQST]),"")

I have had a paper size (Legal/Landscape) issue with a report in a .mde
application for some time. After several unsuccessful attempts to find a
solution in the Newsgroups I pestered Microsoft support until I got the
corrrect answer and again an unsuccessful/no solution. The ...

I have a report which I created using wizard. After that I made changes to
my table (deleted one field called "No" - which served only for 1,2,3..
purpose).
In my report  I assinged the value "=1" to the control source of the

When I publish my reports with Word, I am losing the formatting.  Is there
anything I can do to salvage the formatting that I have made with the reports
in Access?  Or do I just need to re-format them once I get them into Word?  
My real goal is to turn these repoorts into PDF ...

I am using Access 2002 and have a 13 digit number I want to break out digits
7 - 10. The table is to big to send to excel and do it there. How do I do
this?

I got a report which runs from a form interface. The report is chosen from a
combo box among various reports. The report can be run individually from the
same screen if a case number is checked and the number is plugged in. The
other way to run the report is to run for all the ...

I can't seem to figure out how to find where a print job is
being sent for a particular report.  There are two radio
buttons that give an option as to which printer the job is
sent (one is a continuous printer, the other a laser

Help!!! I have only been working Access 2000 for a couple of months now and
have not been able to understand how to match information in two tables. Let
me explain….
Table One

I have a query which lists answers to 25 questions from a survey. The
Answers are True, False and N/A. The query lists any individuals that have
answered False or N/A for any of the 25 questions.
I want to produce a report to show the Indivduals name and then list which

I have created my query and created a report from the query. I want each
record to have a sequential number in the report. The numbers do not relate
to any other field in the database, just numbered items in the report.
Thanks.

I have an Access 2000 database in which I'm programmatically saving a
multi-page report using the OutPutTo command as RTF. Once you view the RTF in
Word, strange characters appear (actually phrases) such as "f4b1" and "!
b73", scattered throughout various areas of the page, ...

Today I read a post regarding leading dots I downloaded it from lebans
website and get it working. Only it shows for some records blanks instead of
dots?  What can cause this problem.
herman

Re Access 97:SP1
I have a report where I am showing a parameter value in the Report Header.
There is no grouping to the report.
The problem is that only the textbox names (not the data they contain) are

I have 2 reports... one has to print to a Laser... the other to an Oki.   If
I open each and "Select A Printer" for each, will it continue to go to that
printer, or must this be coded.  If so, how do I code this?   Thanx - dd