Variable field on report

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top