Report Header ?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have two reports based on one temp table, the temp
table is based on 15 different queries. So for each query
that I run it uses the same report format and just
changes the info in it, everything is done by a macro.

NOW WHAT I want to do is some how put the name of the
querie in the report header as the title, without have to
make 15 different reports. Is this possible and how would
I do it?

Thanks
Rick
 
What that does is give me the name of the temp table
(rndquestions)in all reports. All 15 queries use the same
table just replaces the info in them. So what happens is
that all reports show the same table name (rndquestions)
is there another way or should each querie be set to make
a new table, which I think the =[Report].[RecordSource]
Would work.
Thanks Rick
-----Original Message-----
Text box with Control Source of exactly this:
=[Report].[RecordSource]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have two reports based on one temp table, the temp
table is based on 15 different queries. So for each query
that I run it uses the same report format and just
changes the info in it, everything is done by a macro.

NOW WHAT I want to do is some how put the name of the
querie in the report header as the title, without have to
make 15 different reports. Is this possible and how would
I do it?

Thanks
Rick
Click to expand...


.
Click to expand...
 
I would use code to either create a global variable, add value in a field,
or place a value in a text box in a form. You could then reference any one
of these from a text box or code in your report.

--
Duane Hookom
MS Access MVP


Rick said:
What that does is give me the name of the temp table
(rndquestions)in all reports. All 15 queries use the same
table just replaces the info in them. So what happens is
that all reports show the same table name (rndquestions)
is there another way or should each querie be set to make
a new table, which I think the =[Report].[RecordSource]
Would work.
Thanks Rick
-----Original Message-----
Text box with Control Source of exactly this:
=[Report].[RecordSource]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have two reports based on one temp table, the temp
table is based on 15 different queries. So for each query
that I run it uses the same report format and just
changes the info in it, everything is done by a macro.

NOW WHAT I want to do is some how put the name of the
querie in the report header as the title, without have to
make 15 different reports. Is this possible and how would
I do it?

Thanks
Rick
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top