Problem with report using IIF statement

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

Guest

I have 3 fields

1) Date d'inscription - which I input the day the client signed up

2) Inscription - which I have a table created where I can choose either 3
months or 6 months inscription

3) Date de renouvellement - which is a calculated field that depends on
which option is chosen up above (3 or 6 months):

=IIf([Inscription]=1,DateAdd("m",3,[date d'inscription]),DateAdd("m",6,[date
d'inscription]))


Now, I need to Query on those that are coming up for renewal in the whatever
month I ask it. In my query, I do have the parameter to prompt me to enter
the month. When I create the report, I enter the IIF statement in the
control source but my report is still coming up blank.

Any ideas?

Tracy


which works on my Form, however,
 
I would add a column in the query
RenewalDate: DateAdd("m", IIf(Inscription=1, 3, 6), [Date d'inscription])
You can then use a criteria against this new column.
 
Back
Top