Problem with IIF statement

[TonyWilliams via AccessMonster.com]

I have a report that is produced in June and December, as signified by the
value of a control txtmonth. I want to create an IIF statement so that if the
txtmonth is June the label says
"New deals in 6 months ended [txtmonth]" but if the report is printed in
December the label says
"New deals in Year([txtmonth])"

I had created this IIF statement but it doesn't pick up the fact that it
includes controls:
=IIf(Month([txtmonth])=12,"New deals in Year([txtmonth])","New deals in 6
months ended [txtmonth]")
I think it assumes that all the text in between the quotes is text and not a
field.
Can anyone help?
Thanks
Tony

 

[Marshall Barton]

I have a report that is produced in June and December, as signified by the
value of a control txtmonth. I want to create an IIF statement so that if the
txtmonth is June the label says
"New deals in 6 months ended [txtmonth]" but if the report is printed in
December the label says
"New deals in Year([txtmonth])"

I had created this IIF statement but it doesn't pick up the fact that it
includes controls:
=IIf(Month([txtmonth])=12,"New deals in Year([txtmonth])","New deals in 6
months ended [txtmonth]")
I think it assumes that all the text in between the quotes is text and not a
field.

=IIf(Month(txtmonth)=12,"New deals in " & Year(txtmonth),
"New deals in 6 months ended " & txtmonth)

 

[Al Campagna]

Tony,
Try...
=IIf(Month([txtmonth])=12,"New deals in Year " & [txtmonth],"New deals in 6
months ended " & [txtmonth])
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

Tony,
Marshall's right... I misunderstood the Year(txtMonth) on the True part.
Thought Year was part of the text...
Al

Tony,
Try...
=IIf(Month([txtmonth])=12,"New deals in Year " & [txtmonth],"New deals in
6
months ended " & [txtmonth])
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a report that is produced in June and December, as signified by the
value of a control txtmonth. I want to create an IIF statement so that if
the
txtmonth is June the label says
"New deals in 6 months ended [txtmonth]" but if the report is printed in
December the label says
"New deals in Year([txtmonth])"

I had created this IIF statement but it doesn't pick up the fact that it
includes controls:
=IIf(Month([txtmonth])=12,"New deals in Year([txtmonth])","New deals in 6
months ended [txtmonth]")
I think it assumes that all the text in between the quotes is text and
not a
field.
Can anyone help?
Thanks
Tony

 

[Daryl S]

Tony -

You are right. You need to move the calculation of the year or display of
the month outside of the quotes, and then append them to the quoted text.
Here you go:

=IIf(Month([txtmonth])=12,"New deals in " & Year([txtmonth]),"New deals in 6
months ended " & [txtmonth])

 

[TonyWilliams via AccessMonster.com]

Thanks to all three of you worked just fine!
Tony

I have a report that is produced in June and December, as signified by the
value of a control txtmonth. I want to create an IIF statement so that if the
txtmonth is June the label says
"New deals in 6 months ended [txtmonth]" but if the report is printed in
December the label says
"New deals in Year([txtmonth])"

I had created this IIF statement but it doesn't pick up the fact that it
includes controls:
=IIf(Month([txtmonth])=12,"New deals in Year([txtmonth])","New deals in 6
months ended [txtmonth]")
I think it assumes that all the text in between the quotes is text and not a
field.
Can anyone help?
Thanks
Tony