Parameter Value in Report

[MarieD]

How do I make the parameter value show "Key in the Month"? Right now it displays Date and it works fine, but I want the instruction to be specific.

 

[highandwild]

Do you want the user to enter a numeric (1-12) or the name of the month?

If the former you will need to create a calculated field in the query which returns the number of the month and put the [Key In The Month (For example "3":] in the criteria row of that column.

If the latter you will need to create a calculated field in the query which returns the name of the month and put the [Key In The Month (For example "January":] in the criteria row of that column.

 

[MarieD]

I also want the keyed month name to appear in a field on the report. I may have confused what I need as the end result. Right now the report design looks like: [Text Box 1] Services Rendered in [Text Box 2] = [Date] [Text Box 3] 2010. When I key in the month needed in the paramenter, it places the keyed month name in the field =Date. How do I give instructions on the report side to key in a month name?