IF statement not working
Stefan, thanks for your reply!
I tried inserting the references using Ctrl+F9, but now instead of giving a
result, it comes back with the contents of the first reference. So whatever
number is in REPTotal displays in the field instead of either of the text
values =(
Is there anything else you can think of?
"Stefan Blom" wrote:
Assuming that REPTotal and PrevYearREP are global variables or bookmarks,
they must be inserted as REF fields in your code:
{ IF { REPTotal } { PrevYearREP } "an increase" "a decrease" }
Also, note that each pair of field delimiters, { }, must be added by
pressing Ctrl+F9.
--
Stefan Blom
Microsoft Word MVP
"CPelkey" wrote in message
...
I have a form where the user enters the number of reports for the current
year as well as the number of reports for the previous year. I want to use
this information to automatically tell the user whether the number of
reports
has increased or decreased.
REPTotal is the total reports for the current year
PrevYearREP is the number of reports for the previous year.
Here is the IF statement I am using:
{ IF (REPTotalPrevYearREP "an increase" "a decrease") }
I don't anticipate the numbers ever being the same. For some reason, no
matter what numbers I use, the field ALWAYS displays "an increase". The
field
is not locked, and I have been updating it after changing the numbers.
What am I doing wrong?
.
|