Display Parameter Qry Criteria in Report

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

Don Jellie

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...
 
D

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


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...
 
Top