Report Headers - adding values from a parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Fons,

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

Any other suggestions?

Fons Ponsioen said:
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

C Markowitz said:
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.
Click to expand...
Click to expand...
 
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.

C Markowitz said:
Fons,

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

Any other suggestions?

Fons Ponsioen said:
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

C Markowitz said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top