IIF Question

  • Thread starter Thread starter hispeaches
  • Start date Start date
H

hispeaches

Good Morning,

Having a bit of trouble here and was wondering if someone would be so kind
as to help me find my way...

What I am trying to do is this...

If [Accounts].[AuditMonth] = Month(Now()) then sum([AuditMonth])/30
In a second text box I will take the result of above and * that by the month
number. For instance: If the result from above = 80 then I would like to see
80 * 2 (February - depending upon what the current month is) or 80 * 6 (June
- depending upon what the current month is).

Can someone help me with this? I am quite sure this all could be done via 1
text box which would be wonderful...I am stuck.
 
An IF statement normally has two part, True and False. You only show what
you want to happen if true.
IIf([Accounts].[AuditMonth] = Month(Date()), [AuditMonth]/30 * [AuditMonth],
What now for False?)
 
Back
Top