[Stefan Blom[_3_]]

Clever!

--
Stefan Blom
Microsoft Word MVP



"macropod" wrote in message
...
Hi CPelkey,

Instead of an IF test, try something along the lines of:
{={ REPTotal }-{ PrevYearREP } \# "'an increase';'a decrease';'no
change'"}

Note: The field brace pairs (ie '{ }') for the above example are created
via Ctrl-F9 - you can't simply type them or copy & paste them from this
message.

--
Cheers
macropod
[Microsoft MVP - Word]


"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?