[CPelkey]

macropod,

Thank you sooooooo much, it works perfectly now!!

"macropod" wrote:

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?

.