report not displaying as I need it

  • Thread starter Thread starter MikeSr
  • Start date Start date
M

MikeSr

I have a line chart using a query that has my pH values and date / time stamp
for each record.
I can't seem to display the pH values with out a summery selection like
"AVG" . I just want to display the raw data in a line chart with the dates
across the bottom of the chart and pH scaling shown on the vertical axis
(label).
What am I not doing to accomplish this
 
The wizard is often a little pushy. Just finish and then change the Row
Source property of your chart control.
 
errors in statement corrected below

MikeSr said:
More specificaly,
I have 3 fields within a Table
pH( value ), Ph Timestamp( date/time) , ID (record ID)
When I build a chart using the pH value (vertical axis) and the Timestamp acros the bottom (horizontal axis),
the resolution of the timestamp only shows in whole days, thus my pH data is
reduced to the same.
I need the full resolution of the data ( where there are samples every
minute, and in this test case every second.
I can plot correctly using the ID instead of the date, but then I don't know
when the spikes illustrated in the graph occured with out the time stamp.
Sure could use some advice
Thanks
Click to expand...
 
In the chart Wizard , I am using a line chart.
The Data field is poplulated with the pH data.
The axis field is poplulated with the pH timestamp field.
I have popluated the Axis field with the ID field and this of course shows
all the data. But I need to see the dates within range and all of the ph
Data.

I sure hope I am providing you with correct information. I dont see any way
to provide a jpeg image of the report or the query.
Thanks again
 
The chart control on your report has a Row Source property. This is probably
a SQL statement. It will have a SQL view that you need to copy and paste into
a reply in this thread.
 
I did make one change to the chart options dialog. I changed the "Primary
axis (x) from "Automatic" to "Category". It now plots correctly.
Now if I can get a Line for each date/time shown to plot verticaly to the
data plot line, it would be easier to see. The major grid increments are such
that is make the plot hard to read.
Still learning. Started using this software about 4 days ago, and I have a
lot to learn.
Any good manual to recommend would be apreciated.


SELECT [Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP, [Alarms and
data].UFD_UD_ANALOG_DATA_pH1_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_HiAlarm_SP_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_LowAlarm_SP_VALUE
FROM [Alarms and data]
GROUP BY [Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP, [Alarms and
data].UFD_UD_ANALOG_DATA_pH1_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_HiAlarm_SP_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_LowAlarm_SP_VALUE,
(Int([UFD_UD_ANALOG_DATA_pH1_TIMESTAMP]*1440))
HAVING ((([Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP) Between
[Forms]![Data Range]![Start Date] And [Forms]![Data Range]![End Date]));
 
I don't see why the query is a totals query. You should try change it to:
SELECT [Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP,
[Alarms and data].UFD_UD_ANALOG_DATA_pH1_VALUE,
[Alarms and data].UFD_UD_SP_RT_RT_HiAlarm_SP_VALUE,
[Alarms and data].UFD_UD_SP_RT_RT_LowAlarm_SP_VALUE
FROM [Alarms and data]
WHERE UFD_UD_ANALOG_DATA_pH1_TIMESTAMP
Between [Forms]![Data Range]![Start Date] And [Forms]![Data Range]![End Date];

Your grid lines are set intervals.
--
Duane Hookom
Microsoft Access MVP


MikeSr said:
I did make one change to the chart options dialog. I changed the "Primary
axis (x) from "Automatic" to "Category". It now plots correctly.
Now if I can get a Line for each date/time shown to plot verticaly to the
data plot line, it would be easier to see. The major grid increments are such
that is make the plot hard to read.
Still learning. Started using this software about 4 days ago, and I have a
lot to learn.
Any good manual to recommend would be apreciated.


SELECT [Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP, [Alarms and
data].UFD_UD_ANALOG_DATA_pH1_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_HiAlarm_SP_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_LowAlarm_SP_VALUE
FROM [Alarms and data]
GROUP BY [Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP, [Alarms and
data].UFD_UD_ANALOG_DATA_pH1_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_HiAlarm_SP_VALUE, [Alarms and
data].UFD_UD_SP_RT_RT_LowAlarm_SP_VALUE,
(Int([UFD_UD_ANALOG_DATA_pH1_TIMESTAMP]*1440))
HAVING ((([Alarms and data].UFD_UD_ANALOG_DATA_pH1_TIMESTAMP) Between
[Forms]![Data Range]![Start Date] And [Forms]![Data Range]![End Date]));

Duane Hookom said:
The chart control on your report has a Row Source property. This is probably
a SQL statement. It will have a SQL view that you need to copy and paste into
a reply in this thread.
Click to expand...
Click to expand...
 
Back
Top