Reference page header to query parameters

  • Thread starter Thread starter AccessKay
  • Start date Start date
A

AccessKay

How do you reference a page header in a report to return the parameter that
you selected in your query? For example, I have two calculated fields in my
final query based on two other queries. The two other queries contain the
parameters. The parameters are for month, year and quarter. So if I answer
my parameters like:

Month1: 2
Year1: 2010
Qtr1: 1
Month2: 1
Year2: 2010
Qtr: 1

I want my report headers to reference my selections and return in my
report’s page header:

Feb 2010 Qtr1 Jan 2010 Qt1

I’ll be so incredibly relieved if I can get this to work. I’ve wasted a
colossal amount of time trying to build an unbound form to do this but it
seems to be out of my reach. I sure hope this isn’t too complicated. Thanks
for any help.

Kay
 
IMO, there is no good reason to use parameter prompts in queries. All user
interaction should be through controls on forms.

That said, you can simply place the same parameter in columns. Assuming you
have a parameter like [Enter Year], you can create a new column in your query
of:

EnteredYear: [Enter Year]

Again ;-) a much more professional solution is to always use controls on
forms for user interaction.
 
Thanks you so very much for this answer!!! Not what I really want but it
will have to do.

I definitely agree with you that the unbound form is the way to go but it
seems you have to be very experienced in order to build one for the
parameters that I described...believe me, I've tried!!!

Thank you,
Kay

Duane Hookom said:
IMO, there is no good reason to use parameter prompts in queries. All user
interaction should be through controls on forms.

That said, you can simply place the same parameter in columns. Assuming you
have a parameter like [Enter Year], you can create a new column in your query
of:

EnteredYear: [Enter Year]

Again ;-) a much more professional solution is to always use controls on
forms for user interaction.
--
Duane Hookom
Microsoft Access MVP


AccessKay said:
How do you reference a page header in a report to return the parameter that
you selected in your query? For example, I have two calculated fields in my
final query based on two other queries. The two other queries contain the
parameters. The parameters are for month, year and quarter. So if I answer
my parameters like:

Month1: 2
Year1: 2010
Qtr1: 1
Month2: 1
Year2: 2010
Qtr: 1

I want my report headers to reference my selections and return in my
report’s page header:

Feb 2010 Qtr1 Jan 2010 Qt1

I’ll be so incredibly relieved if I can get this to work. I’ve wasted a
colossal amount of time trying to build an unbound form to do this but it
seems to be out of my reach. I sure hope this isn’t too complicated. Thanks
for any help.

Kay
Click to expand...
Click to expand...
 
Back
Top