471,071 Members | 1,235 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

Chart Dae Problem

I've created a Chart in Access97. It is a time function of a variable.
When the dates along the x axis are within the same year - no problem.

Apr-03 May-03 Jun-03...........Dec-03.

However when I set a two year span I get bum results. For example if I
set the period to be Oct-2002 to March 2003, the x-axis becomes Oct-03
Nov-03 Dec-03 Jan-03 Feb-03 Mar-03. Yes the years are all 03.

When I open the underlying query the dates are in the proper order
Oct 02
Nov 02
Dec 02
Jan 03
Feb 03
Mar 03

Yet when I open the Form with this query , the results are as noted
above - starting with the proper month but with 03 as the years for
all months.

If I set the underlying query date for format to "yyyy mm", the order
shown on the chart is correct - namely 2002-10 2002-11 2002-12
2003-01 2003-02 2003-03.

I need to have the dates correctly in the form Oct-02....Mar-03.
Can someone help me out of this situation??

Nov 12 '05 #1
0 1232

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Brian Shade | last post: by
8 posts views Thread by Prabhakar | last post: by
22 posts views Thread by PeteCresswell | last post: by
9 posts views Thread by Patrick.O.Ige | last post: by
1 post views Thread by Scott H. | last post: by
14 posts views Thread by Wayne | last post: by
reply views Thread by cowboyjunkey | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.