I was wondering if it was possible to do the following:

I have a series of field numbers (12345, 12346, etc...) in one column, and
for my report in MS Access I need to show those field numbers along with
another box that will show cutting dates for those fields. For the Even
field numbers it will show "Cut July 1st - December 31st" and for every Odd
number show "Cut June 15th - December 31st". Can i use an IFF statement to
recongize the number and put in the correct cutting date in the other box.

(I have simplized this probelm because I would have to do this function with
multiple columns, but if any one can get me started i can figure out the
rest).

HELP!

On Wed, 11 Jul 2007 14:24:02 -0700, biggg_fish wrote:

> I was wondering if it was possible to do the following:
>
> I have a series of field numbers (12345, 12346, etc...) in one column, and
> for my report in MS Access I need to show those field numbers along with
> another box that will show cutting dates for those fields. For the Even
> field numbers it will show "Cut July 1st - December 31st" and for every Odd
> number show "Cut June 15th - December 31st". Can i use an IFF statement to
> recongize the number and put in the correct cutting date in the other box.
>
> (I have simplized this probelm because I would have to do this function with
> multiple columns, but if any one can get me started i can figure out the
> rest).
>
> HELP!

Well, you can't use IFF because there 'ain't no' IFF.
You can, however, use IIf.
If I understand your question (and I'm not at all sure I do), then in
an unbound control on your report:
=IIf([FieldName] Mod 2 = 0, "Cut July 1st - December 31st","Cut June
15th - December 31st")

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail