kentwoodjean
Technical User
I have a form with a subform included. The subform has a field for the month/year. In other words, my boss wants the field to appear as: January 2002, February 2002, etc through 2003. Another field shows the forecasted number and as each month passes, I will populate the Actuals field.
Problem is that no matter how hard I try, the months will not stay in order Jan - Dec 2002, and then Jan - Dec 2003 following. the months want to group together and whethere it is ascending or descending, January doesn't even end up at the top. Obviously, something more must be done. Can someone tell me what that is?
Problem is that no matter how hard I try, the months will not stay in order Jan - Dec 2002, and then Jan - Dec 2003 following. the months want to group together and whethere it is ascending or descending, January doesn't even end up at the top. Obviously, something more must be done. Can someone tell me what that is?