Using Month in a calculation
There may be a simple answer to this, but I have a month field that is unrelated to an date within my layout. This value is used to "filter" and enter records related to this month (and year). I'm trying to create an "up" and "down" button that will move through the records accordingly. I have the up and down buttons set to "go to field" with a calculation "Month + 1" or "Month -1". The problem is that I'm not sure weather the Month field should be treated as a text, number, or date to make this work. I orginally had it as a text field that was based on a vlue list that I entered manually. Any suggestions?