Graph trouble

JB_96RS

Registered User.
Local time
Today, 16:33
Joined
Jan 13, 2004
Messages
15
Graph trouble...please help

Hi there! I have placed a line graph in a form of mine. The graph is based upon a query. The problem is: I have a TagId number and a data value in this graph. The TagId number is doing some funky stuff. Some of the numbers display correctly (2-1500) and once I get to 2-3000 they start to show as dates. :( I have looked at the tables where all the data is coming from and they are set to varchar. I just don't know why some show as dates and not others. Any help would be appreciated.

Thanks,

JB
 
There's not much you can tell from the description.

In this case an example might be a good idea. ;)
 
Not sure how else to describe it, but here goes:

I have a form with a chart and subform. The subform shows the results of a query. The chart shows the results of the same query in a chart. The Y axis of the chart shows the TagID from the query. The TagID number is supposed to like this 2-1234. The ID's look fine until I get to 2-3000. At this point they turn into dates like this "FEB-56". The subform shows a the data from the query and the numbers are in the correct 2-1234 format there. So Im not sure where my numbers are getting screwed up.

Thanks,

JB
 

Users who are viewing this thread

Back
Top Bottom