J
jrp444
I need to have charts and reports show the Month and Year. The query that I
am using has the month and year as one of its fields. I can get it to go
into a report when I first make it by making the field one of the fields in
the report and moving it up to the header. However, this will not work with
charts and I can not insert this into previous reports written. I have try
to pull this in by putting a text box in the title and pulling the
information in from the query. I only get a error when viewing the report
(#Name?). Is there a way to get the Month and Year from my query into the
header of my report and into the header of the charts? I need to pull from
the query because this is where the time frame for the report is inputted.
am using has the month and year as one of its fields. I can get it to go
into a report when I first make it by making the field one of the fields in
the report and moving it up to the header. However, this will not work with
charts and I can not insert this into previous reports written. I have try
to pull this in by putting a text box in the title and pulling the
information in from the query. I only get a error when viewing the report
(#Name?). Is there a way to get the Month and Year from my query into the
header of my report and into the header of the charts? I need to pull from
the query because this is where the time frame for the report is inputted.