Transfer Query Results to Report

S

Smiley01

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
 
K

KARL DEWEY

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

Smiley01

Thanks, easy solution, works great!

KARL DEWEY said:
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


Smiley01 said:
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
Click to expand...
Click to expand...
 
Top