H
Hogman
I have a query that returns data segmented by month with field names of Jan,
Feb, Mar, etc. On a report I then manually change three specific labels and
the associated data fields to represent the current month and following two
months. I would like to have the data fields change automatically based on
information that I pull from a different query where the I can retrieve a
value that matches the field name that I want to retrieve the data from. I
can easily change the labels for the report but I'm stuck on how to have the
data field change with it. To change the labels I use a query to retrieve
the appropriate 3 months from a table. The results of that query only has
one record in it. The fields in the record are Month1, Month2, Month3. Each
month the data in these fields update without a problem. Is there a way that
I can use the data from the same query to set which data fields are used in
the final report? As an example, this month I want the report to retrieve
the data from fields May, Jun and Jul but next month I want it to retrieve
the data from Jun, Jul & Aug.
Thanks in advance for any assistance!!
Feb, Mar, etc. On a report I then manually change three specific labels and
the associated data fields to represent the current month and following two
months. I would like to have the data fields change automatically based on
information that I pull from a different query where the I can retrieve a
value that matches the field name that I want to retrieve the data from. I
can easily change the labels for the report but I'm stuck on how to have the
data field change with it. To change the labels I use a query to retrieve
the appropriate 3 months from a table. The results of that query only has
one record in it. The fields in the record are Month1, Month2, Month3. Each
month the data in these fields update without a problem. Is there a way that
I can use the data from the same query to set which data fields are used in
the final report? As an example, this month I want the report to retrieve
the data from fields May, Jun and Jul but next month I want it to retrieve
the data from Jun, Jul & Aug.
Thanks in advance for any assistance!!