V
Vance
Good afternoon!
I've successfully developed 3 charts for 3 separate departments in the
Flooring Mill company that I work for. Each chart a detailed account of all
of the downtime which occurred for a particular week. I'm using a query
which asks the user to input a starting date and an ending date for a
particular week. This work just fine, as the downtime in minutes is charted
perfectly and all Axis's are labeled correctly as well.
I want to use text box in this chart which list the ending date which was
input in query. The problem I'm having is twofold. First of all, when I
make reference to the ending date parameter in the query via the chart
through a text box control, I'm asked twice to enter the ending date. This
is strange indeed. The second problem I'm having is that when I try to
display this text box on the chart it gives me a crazy string which says
"#Name?" where the ending date, a simple short date, should appear.
Has anyone tried to do this before? This method which I'm using works just
great in "regular" text reports written in Access. But something strange
happens when trying to display an ending date from a query input on a chart.
Any ideas you may have will be greatly appreciated. Have a good day!
I've successfully developed 3 charts for 3 separate departments in the
Flooring Mill company that I work for. Each chart a detailed account of all
of the downtime which occurred for a particular week. I'm using a query
which asks the user to input a starting date and an ending date for a
particular week. This work just fine, as the downtime in minutes is charted
perfectly and all Axis's are labeled correctly as well.
I want to use text box in this chart which list the ending date which was
input in query. The problem I'm having is twofold. First of all, when I
make reference to the ending date parameter in the query via the chart
through a text box control, I'm asked twice to enter the ending date. This
is strange indeed. The second problem I'm having is that when I try to
display this text box on the chart it gives me a crazy string which says
"#Name?" where the ending date, a simple short date, should appear.
Has anyone tried to do this before? This method which I'm using works just
great in "regular" text reports written in Access. But something strange
happens when trying to display an ending date from a query input on a chart.
Any ideas you may have will be greatly appreciated. Have a good day!