D
Dennis
I have 7 reports that I need to run. Each report is a copy
of the same report only using similar data from different
cost centers (Same field names, expressions and tables).
So I created 7 queries one for each cost center to provide
the data for each report. I then got the Idea that I could
make only one query with a criteria that asks the user to
input the cost center and then makes the query for only
that cost center's data.
The problem I am having is when I use this query in my
report, the correct expenditure data is reported but the
allotted budget for the cost center is for a different
cost center as it is coded in the below expression. These
2 types of data "Expenditures" (query) and "Allocated
budget" (Table) are extracted differently and then called
into the report. All of the data is gathered into the
report using a SELECT DISTINCTROW query. The expression
for the table is as follows:
Annual Plan Actual: 13601
As mentioned, the Expenditure query's criterion asks the
user to input the cost center (same name as above
expression "13601").
What I would like to do is when this report is opened and
runs the expenditure query (that asks for the cost center
i.e. 13601), I would like the input from the query to some
how change the SELECT DISTINCTROW query field in the above
expression to the matching cost center. This would
effectively match both sides of the report (Allocated
budget and expenditures) to the same cost center. How can
this be done? Thanks
Dennis
of the same report only using similar data from different
cost centers (Same field names, expressions and tables).
So I created 7 queries one for each cost center to provide
the data for each report. I then got the Idea that I could
make only one query with a criteria that asks the user to
input the cost center and then makes the query for only
that cost center's data.
The problem I am having is when I use this query in my
report, the correct expenditure data is reported but the
allotted budget for the cost center is for a different
cost center as it is coded in the below expression. These
2 types of data "Expenditures" (query) and "Allocated
budget" (Table) are extracted differently and then called
into the report. All of the data is gathered into the
report using a SELECT DISTINCTROW query. The expression
for the table is as follows:
Annual Plan Actual: 13601
As mentioned, the Expenditure query's criterion asks the
user to input the cost center (same name as above
expression "13601").
What I would like to do is when this report is opened and
runs the expenditure query (that asks for the cost center
i.e. 13601), I would like the input from the query to some
how change the SELECT DISTINCTROW query field in the above
expression to the matching cost center. This would
effectively match both sides of the report (Allocated
budget and expenditures) to the same cost center. How can
this be done? Thanks
Dennis