Display Parameter Qry Criteria in Report

[Maureen]

I have Access 2002 on WinXP

I have a report which has a parameter query as its
recordsource. All works -

Question: How can I get the criteria for the query/report
(input by user when report is accessed) to be included in
the report header?

 

[Duane Hookom]

Add a text box with a control source of:
=[Your parameter prompt]

 

[Guest]

Hi,

Is it possible to do exactly the same thing when using MS Query to pull the
data back to Excel?
I apologize in advance if this question is considered inappropriate but this
is the only thread I could find even remotely connected to this subject.

Thanks,
Don Jellie

Add a text box with a control source of:
=[Your parameter prompt]

--
Duane Hookom
MS Access MVP
--

I have Access 2002 on WinXP

I have a report which has a parameter query as its
recordsource. All works -

Question: How can I get the criteria for the query/report
(input by user when report is accessed) to be included in
the report header?

 

[Duane Hookom]

There are Excel NGs that would be better for this question. You can
reference a cell to filter the returned values from MS Query.

--
Duane Hookom
MS Access MVP

Hi,

Is it possible to do exactly the same thing when using MS Query to pull the
data back to Excel?
I apologize in advance if this question is considered inappropriate but this
is the only thread I could find even remotely connected to this subject.

Thanks,
Don Jellie

Add a text box with a control source of:
=[Your parameter prompt]

--
Duane Hookom
MS Access MVP
--

I have Access 2002 on WinXP

I have a report which has a parameter query as its
recordsource. All works -

Question: How can I get the criteria for the query/report
(input by user when report is accessed) to be included in
the report header?