Charts for sugar count

[TC]

I have been trying to make a chart from data that is
Access 2002. I have tryed sereval different ways way I
just can't do it. I want the number scale going up the
left side with sugar count in the body of the chart with
the date at the bottom. I think so far that I have to
change date. Because I have the date and time of day. But
everything is in the wrong place.
Can someone help me.
Tom

 

[John Vinson]

I have been trying to make a chart from data that is
Access 2002. I have tryed sereval different ways way I
just can't do it. I want the number scale going up the
left side with sugar count in the body of the chart with
the date at the bottom. I think so far that I have to
change date. Because I have the date and time of day. But
everything is in the wrong place.
Can someone help me.
Tom

You're making the assumption that we can see your database and know
the structure of your tables. We don't. "Sugar count" is not an Access
feature; it's part of your data.

Just at a guess, you might want to put a calculated field in your
table by typing

DateOnly: Datevalue([yourdatefield])

and use it as the X axis.

 

[Philip Martin]

I have been trying to make a chart from data that is
Access 2002. I have tryed sereval different ways way I
just can't do it. I want the number scale going up the
left side with sugar count in the body of the chart with
the date at the bottom. I think so far that I have to
change date. Because I have the date and time of day. But
everything is in the wrong place.
Can someone help me.
Tom

Hmm, this wouldn't be anything to do with DM and BG results would it?

Philip Martin.