Report using > 1 table

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

On a report I use a query for the detail of the data
(multiple record). At the end of the report I want to
bring in several pieces from a completely different table
(single value/single row). If I add the table to the query
it writes the single row values down the column however
many times as are records in the set. I don't want that.

if the report is based on qryMain and I display a column
value in a text box named txtAccount Number.

if I add the table into the qryMain (which I don't want to
do) I can use the following syntax to display the values:
=[qryMain]![txtDocumentNumber]

however, if I don't have it added to the query, when I run
Access, it displays a msgbox as though I was prompting for
a parameter to be entered.

Is it possible to pull data from two unrelated tables into
one report? how?

Thank you in advance
God bless you
 
Build a report based on your other table. Then, you can
put this report into your main report as a subreport.
 
Thank you.
How do I add the 2nd (sub-report) to the main report and
how do I access the fields in that report?
-----Original Message-----
Build a report based on your other table. Then, you can
put this report into your main report as a subreport.
-----Original Message-----
On a report I use a query for the detail of the data
(multiple record). At the end of the report I want to
bring in several pieces from a completely different table
(single value/single row). If I add the table to the query
it writes the single row values down the column however
many times as are records in the set. I don't want that.

if the report is based on qryMain and I display a column
value in a text box named txtAccount Number.

if I add the table into the qryMain (which I don't want to
do) I can use the following syntax to display the values:
=[qryMain]![txtDocumentNumber]

however, if I don't have it added to the query, when I run
Access, it displays a msgbox as though I was prompting for
a parameter to be entered.

Is it possible to pull data from two unrelated tables into
one report? how?

Thank you in advance
God bless you
.
Click to expand...
.
Click to expand...
 
Open your main report in design view. Click on toolbox.
There is a tool for subform/subreport. Click this tool,
then position it wherever you want it to appear in your
main report. It should walk you through the process.
Then, whatever fields are on that report will
automatically print.
-----Original Message-----
Thank you.
How do I add the 2nd (sub-report) to the main report and
how do I access the fields in that report?
-----Original Message-----
Build a report based on your other table. Then, you can
put this report into your main report as a subreport.
-----Original Message-----
On a report I use a query for the detail of the data
(multiple record). At the end of the report I want to
bring in several pieces from a completely different table
(single value/single row). If I add the table to the query
it writes the single row values down the column however
many times as are records in the set. I don't want that.

if the report is based on qryMain and I display a column
value in a text box named txtAccount Number.

if I add the table into the qryMain (which I don't want to
do) I can use the following syntax to display the values:
=[qryMain]![txtDocumentNumber]

however, if I don't have it added to the query, when I run
Access, it displays a msgbox as though I was prompting for
a parameter to be entered.

Is it possible to pull data from two unrelated tables into
one report? how?

Thank you in advance
God bless you
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Les,
Thank you very much. I tried it and will continue to work
with it. I very much appreciate your willingness to help
by sharing your expertise. Thank you.
God bless you.
-----Original Message-----
Open your main report in design view. Click on toolbox.
There is a tool for subform/subreport. Click this tool,
then position it wherever you want it to appear in your
main report. It should walk you through the process.
Then, whatever fields are on that report will
automatically print.
-----Original Message-----
Thank you.
How do I add the 2nd (sub-report) to the main report and
how do I access the fields in that report?
-----Original Message-----
Build a report based on your other table. Then, you can
put this report into your main report as a subreport.

-----Original Message-----
On a report I use a query for the detail of the data
(multiple record). At the end of the report I want to
bring in several pieces from a completely different table
(single value/single row). If I add the table to the
query
it writes the single row values down the column however
many times as are records in the set. I don't want that.

if the report is based on qryMain and I display a column
value in a text box named txtAccount Number.

if I add the table into the qryMain (which I don't want
to
do) I can use the following syntax to display the values:
=[qryMain]![txtDocumentNumber]

however, if I don't have it added to the query, when I
run
Access, it displays a msgbox as though I was prompting
for
a parameter to be entered.

Is it possible to pull data from two unrelated tables
into
one report? how?

Thank you in advance
God bless you
.

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