Transfer Query Results to Report

[Guest]

I have a report that list milestones that is ran off a query. In the query I
ask the user to: Like "*" & [Enter a Key Players Name:] & "*". I would like
the name they enter to show up at the top of the associated report.

Thanks in advance

 

[Guest]

In the design view of the query add an output field to the grid like this --
Operator Input: [Enter a Key Players Name:]

It is best to copy from the query criteria to make sure it is exact
otherwise you will get a prompt for each.

You can use the field in your report.

 

[fredg]

I have a report that list milestones that is ran off a query. In the query I
ask the user to: Like "*" & [Enter a Key Players Name:] & "*". I would like
the name they enter to show up at the top of the associated report.

Thanks in advance

Add an unbound text contropl to the report header.
Set it's Control Source to:

="Show data for " & [Enter a Key Players Name:]

The text within the brackets must be identical to the bracketed text
in the query.

 

[Guest]

Thanks, easy solution, works great!

In the design view of the query add an output field to the grid like this --
Operator Input: [Enter a Key Players Name:]

It is best to copy from the query criteria to make sure it is exact
otherwise you will get a prompt for each.

You can use the field in your report.

--
KARL DEWEY
Build a little - Test a little

I have a report that list milestones that is ran off a query. In the query I
ask the user to: Like "*" & [Enter a Key Players Name:] & "*". I would like
the name they enter to show up at the top of the associated report.

Thanks in advance