Chart by Numeric Quarter not Text

[KayJen]

Hi, I have a query that gathers all necessary data and prints to a chart just fine. My problem is everyone wants the chart to say First, Second, and so on instead of 1, 2 Quarter of (Current Year). I've played with the query and have an IIF statement, this works, however I get multiply printouts of the same chart. Is there a simple solution to changing 1 to First, 2 to Second, 3 to Third and 4 to Fourth. Thanks.

Sonny

 

[GingerR]

where did you put your IIF statement?
what do the multiple printouts look like?
did the charts work fine before you changed to the IIF statement?
what is the record source of your report? (not the chart, but the report that the chart is embedded in)

 

[KayJen]

Removed the IIF statement and chart works fine, but the IIF was in a query. The charts were all the same. What I wanted was First Quarter of 2003, What I currently have is Occuring in Quarter 1 of 2003, which works, was just trying to make my old English teacher happy.

Sonny