Results of IIf Statement

[FormerJarHead]

Good Morning,

In my db, I have an unbound text box that I have the following expression in:
[CODE]
=IIf(Count(*)=0,"There are No Records to Display","Report for the period: " & [Enter Start Date] & " To " & [Enter End Date])
[Code]

This does exactly what the user wanted...until this morning. She now would like it to display the month, for example, if there are no records for August, which is possible, she would like it to say "There are No records to Display for the month of August"

Do I need to include this in my parameter query or can it be placed in the expression?

Thanks for any suggestions...

[June7]

I don't use dynamic parameterized queries. If the input is a popup then the entry on criteria row is not available for further use.

I prefer to have user input criteria into controls on form then use VBA code to set filter of form or report.

What is the criteria input by user? If user inputs a date range such as 8/11/2013 and 9/4/2013, the 'month' comment is not applicable.

[pbaldy]

Well, this should work:

Format([Enter Start Date], "mmmm")

but of course that assumes they entered the first and last days of the month.

[FormerJarHead]

Thank you both for your response.

June7 your example makes perfect sense, however in most cases, the report will be run over the term of 1 consecutive moth 1-31. It is a dynamic query that I'm running for this report because there will not be a need in the future to make it more than it is. Put in the dates, get the data...that's it. I was hoping to do something along the lines of what pbaldy wrote and somehow incorporate that into what I already have.

pbaldy - your example works when I put it in an unbound box without the other expression. I don't know where, or if I can, insert into my existing expression.

[pbaldy]

pbaldy - your example works when I put it in an unbound box without the other expression. I don't know where, or if I can, insert into my existing expression.

In your formula:

=IIf(Count(*)=0,"There are No Records to Display","Report for the month of: " & Format([Enter Start Date], "mmmm"))

The Month() function would return an integer.