Apr 8, 2003 #1 darahw Technical User Feb 27, 2003 74 US Please help- I have created a crosstab report and would like to change the month number being displayed to the actual word value. I think I need to use the Totext in the formula editor but can't find the exact syntax. Thanks in advance!! Dara
Please help- I have created a crosstab report and would like to change the month number being displayed to the actual word value. I think I need to use the Totext in the formula editor but can't find the exact syntax. Thanks in advance!! Dara
Apr 8, 2003 #2 JulsY Programmer Jan 22, 2002 24 US Use Create a formula and use MonthName(month number ) MonthName(5) = May Upvote 0 Downvote
Apr 8, 2003 Thread starter #3 darahw Technical User Feb 27, 2003 74 US That didn't work MonthName(5) =May it is looking for something else. Do you know what else is needed? Upvote 0 Downvote
That didn't work MonthName(5) =May it is looking for something else. Do you know what else is needed?
Apr 8, 2003 #4 JulsY Programmer Jan 22, 2002 24 US It should not be looking for anything else. What version are you using? Also, try this: MonthName(8,False) Upvote 0 Downvote
It should not be looking for anything else. What version are you using? Also, try this: MonthName(8,False)
Apr 9, 2003 Thread starter #5 darahw Technical User Feb 27, 2003 74 US I am running version 8.5 When I use the MonthName(8,False) formula I get a message when I run the report of: A crosstab column has been specified on a non-recurrng field. And it returns nothing. Do you know why this happens? Thank you! Upvote 0 Downvote
I am running version 8.5 When I use the MonthName(8,False) formula I get a message when I run the report of: A crosstab column has been specified on a non-recurrng field. And it returns nothing. Do you know why this happens? Thank you!