Conditonal Expressions that perfom calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for samples of conditional expressions that can add or subtract
between conditions.
i.e If the data in column A equal "November" add the data in column B to the
data in column C; or
If the data in column A equal "November or December" add the data in column
B to the data in column C and column D;
 
Nilson

I might be missing something but that sounds like something I would do in a
query, using an IIF() statement. By the way, in your example, the second
condition would never be triggered for a "November" value, as the first
would catch all "November"s.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top