Display on report...

L

Little pete

How can Show the parameters of a query on the report. Thought i should be
using the 'control source' function.

Thanks for the help
Pete
 
A

AlCamp

Pete,
Say you had a parameter in your query like this [Enter Your Name], and
the user entered "Bob Smith" when the query ran.
On the report, place a text control with a ControlSource of =
[Enter Your Name]
When the report prints, this field will display "Bob Smith"
hth
Al Camp
 
L

Little pete

For some reason I still get an error message when I try and view the report.

In the original query I have this;

Between [Type the first start date range] And [Type the second start date
range]

to select my dates. This dumps the data into a table, I then complete a
crosstab query to display the data in my report. Would this be causing the
issue??

Cheers

AlCamp said:
Pete,
Say you had a parameter in your query like this [Enter Your Name], and
the user entered "Bob Smith" when the query ran.
On the report, place a text control with a ControlSource of =
[Enter Your Name]
When the report prints, this field will display "Bob Smith"
hth
Al Camp


Little pete said:
How can Show the parameters of a query on the report. Thought i should be
using the 'control source' function.

Thanks for the help
Pete
Click to expand...
Click to expand...
 
A

AlCamp

What's the error message?
How did you set up those parameter fields to display on the report?
Al Camp

Little pete said:
For some reason I still get an error message when I try and view the report.

In the original query I have this;

Between [Type the first start date range] And [Type the second start date
range]

to select my dates. This dumps the data into a table, I then complete a
crosstab query to display the data in my report. Would this be causing the
issue??

Cheers

AlCamp said:
Pete,
Say you had a parameter in your query like this [Enter Your Name], and
the user entered "Bob Smith" when the query ran.
On the report, place a text control with a ControlSource of =
[Enter Your Name]
When the report prints, this field will display "Bob Smith"
hth
Al Camp


Little pete said:
How can Show the parameters of a query on the report. Thought i should be
using the 'control source' function.

Thanks for the help
Pete
Click to expand...
Click to expand...
Click to expand...
 
L

Little pete

I get the message 'enter parameter' when I open up the report up. i want to
display the date range used in the query to make the report. But I have
catergorised the dates and the first query results into months for this
report using a cross tab query.

Well over my head now, so thanks for the help


AlCamp said:
What's the error message?
How did you set up those parameter fields to display on the report?
Al Camp

Little pete said:
For some reason I still get an error message when I try and view the report.

In the original query I have this;

Between [Type the first start date range] And [Type the second start date
range]

to select my dates. This dumps the data into a table, I then complete a
crosstab query to display the data in my report. Would this be causing the
issue??

Cheers

AlCamp said:
Pete,
Say you had a parameter in your query like this [Enter Your Name], and
the user entered "Bob Smith" when the query ran.
On the report, place a text control with a ControlSource of =
[Enter Your Name]
When the report prints, this field will display "Bob Smith"
hth
Al Camp


How can Show the parameters of a query on the report. Thought i should be
using the 'control source' function.

Thanks for the help
Pete
Click to expand...
Click to expand...
Click to expand...
 
Top