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.
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.