Pulling date from parameter

[wolfiewoman]

I need to put a date in the report header but it has to be the same month
that the parameter it is asking for. I have a report based off a query
asking the begin date and end date. For this one it is usually a monthly
report. How do I get the month of the report being pulled in the header?

 

[Marshall Barton]

I need to put a date in the report header but it has to be the same month
that the parameter it is asking for. I have a report based off a query
asking the begin date and end date. For this one it is usually a monthly
report. How do I get the month of the report being pulled in the header?

A report's reord source query parameter is available to the
report the same as any field in the query. Just be sure to
refer to it using the **exact** same string as in the query.
E.g. your report header text box could use an expression
like:

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

 

[wolfiewoman]

Thank you. It worked wonderful.

I need to put a date in the report header but it has to be the same month
that the parameter it is asking for. I have a report based off a query
asking the begin date and end date. For this one it is usually a monthly
report. How do I get the month of the report being pulled in the header?

A report's reord source query parameter is available to the
report the same as any field in the query. Just be sure to
refer to it using the **exact** same string as in the query.
E.g. your report header text box could use an expression
like:

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