Display Parameter Qry Criteria in Report

  • Thread starter Thread starter Maureen
  • Start date Start date
M

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?
 
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

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

--
Duane Hookom
MS Access MVP
--

Maureen said:
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?
Click to expand...
Click to expand...
 
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


Don Jellie said:
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

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

--
Duane Hookom
MS Access MVP
--

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