Graph trouble

[JB_96RS]

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

 

[JB_96RS]

Anyone?

 

[Mile-O]

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

In this case an example might be a good idea.

 

[JB_96RS]

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

 

[Mile-O]

Not sure how else to describe it

In this case an example might be a good idea.

A physical database example?