Report Headers - adding values from a parameter query

[Guest]

I have a parameter query that prompts the user for month begin and end dates
- I want my report to use the month supplied by the query and add it to the
report header.

I also don't want the user to be prompted again for the values when the
report is run - I tried the example of entering the data when running the
report but if I don't add the prompt to the query I get unwanted results in
the report.

Any suggestions?

Thanks.

 

[Guest]

Hi.
Assuming you have a criteria in your query something like:
Between [Start Month] and [End Month]
you would put exactly the same variables in an unbound textbox in your
report headerlike:
="Between "&[Start Month]& " and " & [End Month]
Hope this helps.
Fons

 

[Guest]

Fons,

I appreciate the tip but this prompts the user for input - I don't want to
prompt the user again.

Any other suggestions?

Hi.
Assuming you have a criteria in your query something like:
Between [Start Month] and [End Month]
you would put exactly the same variables in an unbound textbox in your
report headerlike:
="Between "&[Start Month]& " and " & [End Month]
Hope this helps.
Fons

I have a parameter query that prompts the user for month begin and end dates
- I want my report to use the month supplied by the query and add it to the
report header.

I also don't want the user to be prompted again for the values when the
report is run - I tried the example of entering the data when running the
report but if I don't add the prompt to the query I get unwanted results in
the report.

Any suggestions?

Thanks.

 

[Guest]

If the variable in the query and the report are identical, the user should be
prompted only once for each item (start and end) or you could modify it for a
monthwhere only one entry has to be made.

Fons,

I appreciate the tip but this prompts the user for input - I don't want to
prompt the user again.

Any other suggestions?

Hi.
Assuming you have a criteria in your query something like:
Between [Start Month] and [End Month]
you would put exactly the same variables in an unbound textbox in your
report headerlike:
="Between "&[Start Month]& " and " & [End Month]
Hope this helps.
Fons

I have a parameter query that prompts the user for month begin and end dates
- I want my report to use the month supplied by the query and add it to the
report header.

I also don't want the user to be prompted again for the values when the
report is run - I tried the example of entering the data when running the
report but if I don't add the prompt to the query I get unwanted results in
the report.

Any suggestions?

Thanks.