Display on report...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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