Pulling date from parameter

  • Thread starter Thread starter wolfiewoman
  • Start date Start date
W

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?
 
wolfiewoman said:
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?
Click to expand...


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")
 
Thank you. It worked wonderful.

Marshall Barton said:
wolfiewoman said:
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?
Click to expand...


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")
Click to expand...
 
Back
Top