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
(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