query expression help tying Year filter to unbound text box

[Kemidan2014]

I have a pair of querys that fills graphs for a report. my original expression for a Date field for the querys was simply "Year(Date())-1" which correctly graphed the data for the last year

I know that if i want to view this year only i would just do Year(Date()) but since we review the data for the previous month instead of the current month when January rolls around to review Decembers data then everything would be zeroed out or with only January of current year data

I put an unbound text box on my Frontpage form called [evalyear] i tried the following syntax Year([Forms]![FrontPage]![evalyear]) so that we can leave 2023 for this year in there and until we have the meeting in next january before we change the year but the results blanked out all the graphs to which i KNOW there should be some small amount of data in it i even put 2022 to see if it would populate the original data I was confirming with.

essentially i want the user on the front end to not have to mess with the query expression so the unbound text box was my way of making it a little more dynamic t filter for the year

 

[Micron]

I think you'd want to use bound object frames, unless the data won't change after the chart is gathered? Why not just use Excel to view the charts?

 

[Kemidan2014]

because that violates the "one stop shop" mentality that i am going with this database. but i think i might have to set up the macro to also open the file to a target sheet and be done with it.

 

[Micron]

That's what I did for a project. I pushed the data from Access to Excel using a dynamic named range. So first the range data was deleted because the data was volatile, then the data was copied to the range. Access form button took care of migrating data and opening the chart.