J
Jade
I have the majority of a report set up the way I want,
based on a query (qry2004dta). I do have some calculated
text fields in my report. Now what I would like to do is
bring in several fields of data from another table
(tbl2004Q1), to use in some additional calculations.
Is it possible to create text boxes in my report that
refer to specific fields in tbl2004Q1, even though the
table isn't part of the underlying query.? Or, should I
create a subreport of the data fields I need from
tbl2004Q1. Is it possible then to have calculated text
boxes in the report based on data from both qry2004dta
and tbl2004Q1?
Or, final thought-there are just eight fields in my
table, tbl2004Q1 (the data in the eight fields will
change each quarter). Should I create a form and just
refer to these form fields in my report? Just trying to
figure out the best way to do this.
Thanks in advance!
based on a query (qry2004dta). I do have some calculated
text fields in my report. Now what I would like to do is
bring in several fields of data from another table
(tbl2004Q1), to use in some additional calculations.
Is it possible to create text boxes in my report that
refer to specific fields in tbl2004Q1, even though the
table isn't part of the underlying query.? Or, should I
create a subreport of the data fields I need from
tbl2004Q1. Is it possible then to have calculated text
boxes in the report based on data from both qry2004dta
and tbl2004Q1?
Or, final thought-there are just eight fields in my
table, tbl2004Q1 (the data in the eight fields will
change each quarter). Should I create a form and just
refer to these form fields in my report? Just trying to
figure out the best way to do this.
Thanks in advance!