Charts in a report

  • Thread starter Thread starter Dan Johnson
  • Start date Start date
D

Dan Johnson

Hello,

I have a report with the cost of equipment in a line chart to graph those costs. The data is entered once per month and as long as I graph the data across the entirety of the table, the chart works as it should. If I add a between statement to the query upon which the chart is based, the chart will not display and the date for each piece of equipment is asked again and again until the report displays. Once the report displays, it does not show the data in the chart but does display the numerical information for the hard data. Anyone have any suggestions?
 
Share how "I add a between statement to the query". I doubt anyone can see
your application.

--
Duane Hookom
MS Access MVP


Hello,

I have a report with the cost of equipment in a line chart to graph those
costs. The data is entered once per month and as long as I graph the data
across the entirety of the table, the chart works as it should. If I add a
between statement to the query upon which the chart is based, the chart will
not display and the date for each piece of equipment is asked again and
again until the report displays. Once the report displays, it does not show
the data in the chart but does display the numerical information for the
hard data. Anyone have any suggestions?
 
The between statement is for the date of service and with the wizard the
syntax is:

Between [Enter: Beginning Date] And [Enter: Ending Date]. The chart works
like it should until I narrow to a date range.
 
Abandon parameter prompt queries in favor of references to controls on
forms. I would not go any further until this has been created.

--
Duane Hookom
MS Access MVP
--

Dan Johnson said:
The between statement is for the date of service and with the wizard the
syntax is:

Between [Enter: Beginning Date] And [Enter: Ending Date]. The chart works
like it should until I narrow to a date range.
Click to expand...
 
Duane,

Won't it be the same problem, though? Whether you do it in a form or a
query, the date data will still need to be filtered across the desired
range.

--
Dan Johnson


Duane Hookom said:
Abandon parameter prompt queries in favor of references to controls on
forms. I would not go any further until this has been created.

--
Duane Hookom
MS Access MVP
--

Dan Johnson said:
The between statement is for the date of service and with the wizard the
syntax is:

Between [Enter: Beginning Date] And [Enter: Ending Date]. The chart works
like it should until I narrow to a date range.

--
Dan Johnson


Duane Hookom said:
Share how "I add a between statement to the query". I doubt anyone can
see your application.

--
Duane Hookom
MS Access MVP


Hello,

I have a report with the cost of equipment in a line chart to graph
those costs. The data is entered once per month and as long as I graph
the data across the entirety of the table, the chart works as it should.
If I add a between statement to the query upon which the chart is based,
the chart will not display and the date for each piece of equipment is
asked again and again until the report displays. Once the report
displays, it does not show the data in the chart but does display the
numerical information for the hard data. Anyone have any suggestions?
Click to expand...
Click to expand...
Click to expand...
 
All of your record sources and rowsources can reference the same controls on
your form. You would avoid all the prompting.

--
Duane Hookom
MS Access MVP
--

Dan Johnson said:
Duane,

Won't it be the same problem, though? Whether you do it in a form or a
query, the date data will still need to be filtered across the desired
range.

--
Dan Johnson


Duane Hookom said:
Abandon parameter prompt queries in favor of references to controls on
forms. I would not go any further until this has been created.

--
Duane Hookom
MS Access MVP
--

Dan Johnson said:
The between statement is for the date of service and with the wizard the
syntax is:

Between [Enter: Beginning Date] And [Enter: Ending Date]. The chart
works like it should until I narrow to a date range.

--
Dan Johnson


Share how "I add a between statement to the query". I doubt anyone can
see your application.

--
Duane Hookom
MS Access MVP


Hello,

I have a report with the cost of equipment in a line chart to graph
those costs. The data is entered once per month and as long as I graph
the data across the entirety of the table, the chart works as it
should. If I add a between statement to the query upon which the chart
is based, the chart will not display and the date for each piece of
equipment is asked again and again until the report displays. Once the
report displays, it does not show the data in the chart but does
display the numerical information for the hard data. Anyone have any
suggestions?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top