A
Alex
I have a query with a text field called TermDate with entries like Jan/04,
Feb/04, Qtr 1/04, Qtr 2/04, etc... The TermDate field is a text field and
I've joined it with another table to put them in the order I want. The query
runs fine, however when I run a report using this query as my chart data
source it still thinks these are dates and if I change the chart axis number
format to text I get date serial numbers. Any idea how I can fix this?
Thank you.
Feb/04, Qtr 1/04, Qtr 2/04, etc... The TermDate field is a text field and
I've joined it with another table to put them in the order I want. The query
runs fine, however when I run a report using this query as my chart data
source it still thinks these are dates and if I change the chart axis number
format to text I get date serial numbers. Any idea how I can fix this?
Thank you.