I will give this thing one more try. Fresher minds prevail on Monday's.
I have several charts that work off of a query.
The several charts all compare various variables to year.
I have wasted an enormous amount of time simply trying to filter my charts by year. A single field in my table that is an integer with 0 decimal places. All the dates are entered as a 4 digit number. Ex 2006.
I created the charts and they all work great. However, the user now wants to be able to select or compare various years as opposed to seeing them all in every chart.
I tested the query that all the charts are based on to see if it filters properly.
The query works fine. However, if I try to run the charts I get the error message, "The microsoft jet database engine does not recognize '[Enter the desired year]'as a valid field name or expression."
My end desire is to have a form with two text boxes named "start" and "end" in addition to a number of butons each corresponding to one of the charts. My user will enter two years, one in each of the text boxes "start" and "end"
When he/she presses one of the chart butons, the corresponding chart will open up showing only the two (or) one selected years' data. This would be filtered by the query that all of the charts are based on that has a set criteria, "Like [forms].[charts].[start] or like [forms].[charts].[end]"
As I mentioned earlier, I already have this all set up. The query works fine based on all of the above. However, if I click the butons or try to open a chart I get the message stated above.
Thanks again to all here at the forum for your invaluable help.
I will attatch the database. I altered names and locations for privacy reason. However, the database is the real deal. It is simple. However, it has caused me to write off a couple hours.
Thanks again to all.
I have several charts that work off of a query.
The several charts all compare various variables to year.
I have wasted an enormous amount of time simply trying to filter my charts by year. A single field in my table that is an integer with 0 decimal places. All the dates are entered as a 4 digit number. Ex 2006.
I created the charts and they all work great. However, the user now wants to be able to select or compare various years as opposed to seeing them all in every chart.
I tested the query that all the charts are based on to see if it filters properly.
The query works fine. However, if I try to run the charts I get the error message, "The microsoft jet database engine does not recognize '[Enter the desired year]'as a valid field name or expression."
My end desire is to have a form with two text boxes named "start" and "end" in addition to a number of butons each corresponding to one of the charts. My user will enter two years, one in each of the text boxes "start" and "end"
When he/she presses one of the chart butons, the corresponding chart will open up showing only the two (or) one selected years' data. This would be filtered by the query that all of the charts are based on that has a set criteria, "Like [forms].[charts].[start] or like [forms].[charts].[end]"
As I mentioned earlier, I already have this all set up. The query works fine based on all of the above. However, if I click the butons or try to open a chart I get the message stated above.
Thanks again to all here at the forum for your invaluable help.
I will attatch the database. I altered names and locations for privacy reason. However, the database is the real deal. It is simple. However, it has caused me to write off a couple hours.
Thanks again to all.
