IIF STATEMENT

[ADD NEW DATA IN FORM?]

Keep in mind that I have most of the fields. the only thing I don't have
which should be include in the statement are the dates. I have the RACC
field, serving size, sodium, cholesterol etc... I just don't know how to do
this IIf statement

SODIUM: Before January 1, 1998: <=480 mg per RACC and per Serving, EXCEPT if
RACC <=30g-- <=480 mg per 50 g of food; after January 1, 1998: this level
reduces to <=360 mg

CHOLESTEROL: <=60 mg per RACC, per serving, and if RACC <=30g per 50g of food

 

[BruceM]

You posted this exact question a week ago in the Forms group. Two people,
including me, responded. In both cases we asked for additional information
that you did not provide. Perhaps you did not understand the questions, in
which case a request for clarification would have been appropriate. If you
are going to repost the same question you should at least acknowledge that
you are doing so in order that people who respond to this thread do not end
up repeating what has already been suggested.