Parameter Value from Crosstab

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Good Day:

I have a report based on a crosstab parameter query. The crosstab is getting
it's data from another query that has a field for date of data input
(datInputDate). The parameter input value is the year portion of
datInputDate.

I do not want the input dates to show in my crosstab because they vary too
much. However, my report titles will need to differentiate between years, so
I would like to (SOMEHOW) capture the input year so that I can use it in the
header of the report.

I have 3 reports that I need to do this with.

Many thanks in advance.

Claire
 
Get away from using parameter queries. They have very little control and
don't provide near the functionality that a control on a form can use.
Change your parameters to something like:
Forms!frmYourForm!txtYear
This allows you to reference the form control on your report.
 
Thanks Duane.

I had wondered about using a form with just a text box.

To do what you have suggested, I would have to keep the "parameter" form
open and have it close after the report. Also, I would add the criteria
Forms!frmYourForm!txtYear to the first query, not the crosstab.
Is that correct?

Claire

Get away from using parameter queries. They have very little control and
don't provide near the functionality that a control on a form can use.
Change your parameters to something like:
Forms!frmYourForm!txtYear
This allows you to reference the form control on your report.
 
Also, is there a way to use just one "parameter" form for the 3 reports I
need to open. Depending on which button I push to activate the form it would
determine which report to preview?

Thanks

Thanks Duane.

I had wondered about using a form with just a text box.

To do what you have suggested, I would have to keep the "parameter" form
open and have it close after the report. Also, I would add the criteria
Forms!frmYourForm!txtYear to the first query, not the crosstab.
Is that correct?

Claire

Get away from using parameter queries. They have very little control and
don't provide near the functionality that a control on a form can use.
Change your parameters to something like:
Forms!frmYourForm!txtYear
This allows you to reference the form control on your report.
 
Yes, the form would need to remain open until the report closes. You could
make it invisible and then never have to close it.

The criteria should be added to the first query. The parameter can (I
believe) be entered into any of the "child" queries but I recommend adding
it to the first query where used.
 
Back
Top